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?