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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When a number as text is multiplied with 1 it is turned into a number.
ASKER