return the price of an item in a cell

[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

 

[Shane Devenshire]

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)

 

[T. Valko]

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)