I am having trouble with the VLOOKUP function. On a separate sheet, I have
all my Part Numbers listed with the associated information. Some of my part
numbers contain letters, such as 21112471L, and others are just numbers.
Therefore, there is no logical sorting going on in my 'database' of part
numbers. Because of this, I have been using the false range_lookup to find an
exact match.

The vlookup function is returning the correct information for the part
numbers which only contain numbers, but returns a "N/A" error for the ones
which end with a letter (such as above). How can I get the function to
return info for both number and alpha entries?

The vlookup formula with a false should return the correct answer even if the
number has a letter at the end or in the middle, Your problem maybe trailing
or leading blank spaces, check for that in on of those values you know is
there and where vlookup is returning #NA
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"MrGator" wrote:

I am having trouble with the VLOOKUP function. On a separate sheet, I have
all my Part Numbers listed with the associated information. Some of my part
numbers contain letters, such as 21112471L, and others are just numbers.
Therefore, there is no logical sorting going on in my 'database' of part
numbers. Because of this, I have been using the false range_lookup to find an
exact match.

The vlookup function is returning the correct information for the part
numbers which only contain numbers, but returns a "N/A" error for the ones
which end with a letter (such as above). How can I get the function to
return info for both number and alpha entries?