Forum Discussion
Solved
Vlookup issue
Hi Expertises, Need you help again. I have a problem in vlookup as below 736 1234 736123 1234 88Q 2345 88Q567 #VALUE! I need to extract the first left 3 characters from the d...
=VLOOKUP(IFERROR(VALUE(LEFT(C1,3)),TEXT(LEFT(C1,3),0)),$A$1:$B$4,2,FALSE)This formula works for the sample data in my worksheet.
=VLOOKUP(IFERROR(VALUE(LEFT(C1,3)),TEXT(LEFT(C1,3),0)),$A$1:$B$4,2,FALSE)This formula works for the sample data in my worksheet.
Thank you so much.