return the price of an item in a cell
 

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

return the price of an item in a cell
 

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 this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Foxrun" wrote:

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

return the price of an item in a cell
 

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)

--
Biff
Microsoft Excel MVP


"Foxrun" wrote in message
...
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