I have attached the file. Why is this simply vlookup not working?
I have attached the file. Why is this simply vlookup not working?
Try( LEFT returns a string and your lookup value is a number)Please Login or Register to view this content.
Dear fredmeister,
Which result do you want?
Regards,
Nandkumar Satpute
Left is a Text Function and it returns text result. So comparing the Text Number with the real number in your vlookup is causing #N/A error.
using -- (Unary Operator) in front of Text result or Using Value function will convert the Text Number to Real Number.
=VLOOKUP(--LEFT(A2,4),Sheet2!A:D,4,0)
or
=VLOOKUP(VALUE(LEFT(A2,4)),Sheet2!A:D,4,0)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Attached is the solution.
Below is the formula.
Formula:Please Login or Register to view this content.
You will need to add in "Value" formula. It will convert the Text to number.
If it helps you, please consider click on the star .
Click * to reward me...
Thank you...
use following formula
=VLOOKUP(VALUE(LEFT(A2,4)),Sheet2!$A$1:$D$1,4,FALSE)
Regards,
Nandkumar Satpute
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks