Check for spaces or other non-printing characters in bothe the search
argument and the list. You can use the LEN() function to see how many
characters Excel think there are and compare that with what you see
Also, check that both are numeric or both are text (with the ISTEXT() or
ISNUMBER() function)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Lorina" wrote in message
...
I have pulled some data into a spreadsheet from an Access database (model #
and ATP)

My vlookup formula is this =VLOOKUP(B6,live,2,FALSE)
B6 is the model # , live is the name I gave the data from Access, 2 is the
2nd field in my list from Access (#1 is model and #2 is ATP) and false
because they are not in sequential order when they import from Access. I
always get n/a and I can't figure out why!

thanks