Liz has attended:
SharePoint course
Vlookup for a whole column using cell reference
I am using V lookup.
The values involved are number stored as text, both in the working spreadsheet and in the lookup area. Some of the formulas work, others don't, they return #N/A.
Why would this be and how can I correct it please?
RE: Vlookup for a whole column using cell reference
Hi Liz,
One possible solution I can suggest is writing the formula as follows:
=VLOOKUP(VALUE(E2),A1:B100,2,FALSE)
The Value function will look at the numeric values of the numbers stored as text.
If this doesn't work, you could select all numbers stored as text and convert them to numbers (if you are allowed to do this).
Alternatively, check the numbers in the rows where you get error messages for spaces before or after the numbers. Spaces cause mismatches. You could use the Trim function to remove spaces.
I hope this helps.
Kind regards
Marius Barnard
Excel Trainer
