software

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

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.

quot;maryjquot; wrote:

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

Thanks - I tried that - it doesn't work. It does not always bring in the
correct result.
--
maryjquot;Iskus23quot; wrote:

gt; When using VLookups, if you leave the final field blank instead of saying
gt; false, it will find fields that are close. See if this helps.
gt;
gt; quot;maryjquot; wrote:
gt;
gt; gt; On one sheet I have a list of complete UPC codes. On another sheet, the UPC
gt; gt; codes are only partial numbers. I need to do a look up to match the partial
gt; gt; UPC with the full UPC.
gt; gt; --
gt; gt; maryj

Do you have any other fields that would match exactly? Perhaps you could do
the Vlookup using one of those.

quot;maryjquot; wrote:

gt; Thanks - I tried that - it doesn't work. It does not always bring in the
gt; correct result.
gt; --
gt; maryj
gt;
gt;
gt; quot;Iskus23quot; wrote:
gt;
gt; gt; When using VLookups, if you leave the final field blank instead of saying
gt; gt; false, it will find fields that are close. See if this helps.
gt; gt;
gt; gt; quot;maryjquot; wrote:
gt; gt;
gt; gt; gt; On one sheet I have a list of complete UPC codes. On another sheet, the UPC
gt; gt; gt; codes are only partial numbers. I need to do a look up to match the partial
gt; gt; gt; UPC with the full UPC.
gt; gt; gt; --
gt; gt; gt; maryj

I wish there was another field to use.
--
maryjquot;Iskus23quot; wrote:

gt; Do you have any other fields that would match exactly? Perhaps you could do
gt; the Vlookup using one of those.
gt;
gt; quot;maryjquot; wrote:
gt;
gt; gt; Thanks - I tried that - it doesn't work. It does not always bring in the
gt; gt; correct result.
gt; gt; --
gt; gt; maryj
gt; gt;
gt; gt;
gt; gt; quot;Iskus23quot; wrote:
gt; gt;
gt; gt; gt; When using VLookups, if you leave the final field blank instead of saying
gt; gt; gt; false, it will find fields that are close. See if this helps.
gt; gt; gt;
gt; gt; gt; quot;maryjquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; On one sheet I have a list of complete UPC codes. On another sheet, the UPC
gt; gt; gt; gt; codes are only partial numbers. I need to do a look up to match the partial
gt; gt; gt; gt; UPC with the full UPC.
gt; gt; gt; gt; --
gt; gt; gt; gt; maryj


Mary,

Try this.

=SUMPRODUCT((ISNUMBER(SEARCH(A1,Sheet3!$A$1:$A$4,1 )))*(Sheet3!$A$1:$A$4))

This is where A1 is your partial code and Sheet3!A1:A4 is your complete
codes. Copy this down your list of partials. This also assumes that
your partials will be unique to only one complete code.

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=539879