VLOOKUP function with embedded LEFT
cm wrote:
I have duplicated your error; the values in your lookup table in sheet2,
a1.... are numbers; replace your formual as follows:
=VLOOKUP(VALUE(LEFT(F2,3)),Sheet2!A1:B335,2,FALSE)
or this:
=VLOOKUP(--LEFT(F2,3),Sheet2!A1:B335,2,FALSE)
|