This mismatch between numbers and text will cause VLOOKUP to return an #N/A error.
it’s possible for you to do this byprefacing the number with a single quote(').
VLOOKUP will then correctly find the table and perform the lookup.
A better solution is to confirm the lookup values in the table are indeed numbers.
when you obtain converted the first column to numeric values, the standard VLOOKUP formulas above will work.
you could do this byconcatenatinganempty string("") to the lookup value inside VLOOKUP.
The formulas below show what this looks like.
If that throws an error, we hit it one more time with the revised formula above.
If that formula also fails, VLOOKUP will return an #N/A error as always.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
