vlookup not working

  • Thread starter Thread starter SteveM
  • Start date Start date
S

SteveM

I have a vlookup table and I import data to a range on a
spreadsheet. The lookup table should populate
information about the data in the columns I import.

This works fine when I test the lookup by copying some
data from the table to the columns I want the information
for but when I copy in live data, or type in live data, I
can't get the lookup to do anything. I have compared
formats and tried a verity of formats for both the table
and the imported data but I don't see any difference.
The vlookup just ignores the data in the newly populated
fields.

Does anyone know why the lookup table will not work?
 
Perhaps the imported data is being treated as text, and you're trying to
match it to numbers.

You could try changing the lookup value to Text in the VLookup formula:

=VLOOKUP(TEXT(B2,"0"),$I$1:$J$12,2,0)
 
Back
Top