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

Try

=IF(ISNA(VLOOKUP(B6,live,2,FALSE)),"",VLOOKUP(B6,l ive,2,FALSE))


If this post helps click Yes
---------------
Jacob Skaria


"Lorina" wrote:

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

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

Oops...I thought you are looking to handle n/a..ok ..Since the data is
imported from Access, check few matching entries for any space/special
character before or after the entries..

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

=IF(ISNA(VLOOKUP(B6,live,2,FALSE)),"",VLOOKUP(B6,l ive,2,FALSE))


If this post helps click Yes
---------------
Jacob Skaria


"Lorina" wrote:

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