Lookup Values from a List

  • Thread starter Thread starter Lisa Beach
  • Start date Start date
L

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
 
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.
 
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
 
Back
Top