Lookup Values from a List

[Lisa Beach]

I know how to do this in Access, but I can't figure out how to do it in
Excel. Not sure if it's an IF statement, LOOKUP, INDEX, or something
else...

Here's the scenario -
I have a delimited list that I received from a Vendor that contains Date,
Customer, Doc #, Doc Date, SKU and Amount. I need to add one more column
with the Item Description. I have a table of SKU's and the corresponding
Item Description.

I need a formula for the Item Description column that looks at the value in
the SKU column, looks at the table of SKU's and enters the correct item
description.

The delimited list I receive from the Vendor weekly and contains about 400
rows of data and there are a total of 20 SKU's.

Thanks in advance for your help.

Lisa

 

[Guest]

This is a good scenario for VLOOKUP. You can check the help for the formula,
as there are some examples there that may guide you.

Hope this helps,
Miguel.

 

[Pete_UK]

Assuming your table of SKUs and Descriptions occupies cells M1 to N20,
and that the main data is in columns A to F with headers in row 1,
enter this formula in G2:

=VLOOKUP(E2,M$1:N$20,2,0)

Adjust cell references to suit. You can copy this down your 400 rows of
data by just double-clicking the fill handle (the small black square in
the bottom right corner of the cursor).

Hope this helps.

Pete