vlookup with search?
Do you have any other fields that would match exactly? Perhaps you could do
the Vlookup using one of those.
"maryj" wrote:
Thanks - I tried that - it doesn't work. It does not always bring in the
correct result.
--
maryj
"Iskus23" wrote:
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
|