Link to home
Start Free TrialLog in
Avatar of Wonderwall99
Wonderwall99

asked on

Vlookup Help

Hi,

I created a vlookup to pick up the first left 5 of '16104 - Tabs' to see if it falls within a list that only has the first 5 '16104'.  I attached an example if you can please assist.  Here is the vlookup I created - please no VBA solutions, I need a rather simple solution so I can modify if needed.


 =VLOOKUP(LEFT(A2,5),'Item List B'!A:A,1,0)
Book1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wonderwall99
Wonderwall99

ASKER

Worked perfectly!  What does the *1 do in the formula?  I wouldn't have thought to use this
When a number as text is multiplied with 1 it is turned into a number.