return the price of an item in a cell

  • Thread starter Thread starter Foxrun
  • Start date Start date
F

Foxrun

I have a worksheet that contains 3 columns, SKU, desc, and price. In a
separate table I want a column where I can type in a SKU and have the price
displayed. I can't seem to get the vlookup to work properly. Any help would
be appreciated.

Harry
 
Hi,

When you can't get a formula to work you should post the formula, some
sample data and tell us what you are getting and what you expect.

=VLOOKUP(A1,Sheet2!A1:C1000,3,FALSE)
 
If each SKU is unique try using the SUMIF function:

A1:A100 = SKUs
C1:C100 = price

E1 = some SKU

=SUMIF(A1:A100,E1,C1:C100)
 
Back
Top