This must be impossible!

T

thelightners

There are three fields relevent to the problem. One field contains data
labled "Description". Included within the descriptions is an "item
identifier". The Data in the second Field is Labled "Inventory SKU".
I get a list labled "out of stock"(which are item identifiers) from
the supplier, and need to search the Description fiels and return the
coresponding "Inventory SKU"'s.
I know it sounds crazy, but I'm stuck with it.
 
B

Biff

Hi!

A1:A1000 = "item identifier"
B1:B1000 = "Inventory SKU"
C1:C1000 = "out of stock"

In D1 enter this formula and copy down to cell D1000 or just double click
the fill handle:

=VLOOKUP(C1,A$1:B$1000,2,0)

If a match is not found the formula will return #N/A. If you don't want to
display the #N/A's change the formula to:

=IF(ISNA(VLOOKUP(C1,A$1:B$1000,2,0)),"",VLOOKUP(C1,A$1:B$1000,2,0))

Biff
 
Top