Is the data sorted? If so, add ,False at the end

=VLOOKUP(value,lookup_table,col, False)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"gersumabat" wrote in message
...
Does Vlookup match text exactly? In other words if I have part number
that's
got -, and alphanumeric characters, can Vlookup function in the table? If
not, is there a workaround. I currently have a spreadsheet formatted as
text
and keep getting the #NA error even though I can do a manual search and
find
matches.