How to find values in a list of text fields
Be careful! Yes, if you don't have leading zeros in codes in SheetB!A:B. No,
if you have!
Stefi
ezt *rta:
If I just change the formula to
=VLOOKUP(TEXT(A2,"0"),SheetB!A:B,2,FALSE)
it will handle different length text strings.
Excellent!
|