When using VLookups, if you leave the final field blank instead of saying
false, it will find fields that are close. See if this helps.

"maryj" wrote:

On one sheet I have a list of complete UPC codes. On another sheet, the UPC
codes are only partial numbers. I need to do a look up to match the partial
UPC with the full UPC.
--
maryj