vlookup not working

[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?

 

[Debra Dalgleish]

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)