if function...i'm not sure..please help

[destiny]

my worksheet layout looks like this:
"ITEM #".."QTY".."TOTAL PRICE"

THOSE ARE THE THREE FIELDS I HAVE. WHAT I WANT TO DO IS
WHEN I ENTER AN "ITEM #" VALUE AND THE "QTY" VALUE, I WANT
THE "TOTAL PRICE" VALUE AUTOMATICALLY ADD UP. I DON'T WANT
TO REFER TO MY PRICE LIST AND DO THE CALCULATION
MANUALLY. PLEASE HELP...

THANK YOU VERY MUCH..
DESTINY

 

[JulieD]

Hi

where's the price list?

assuming the price list is in sheet2:A2:B100, where column A has the product
number and column B has the prices, you can use a VLOOKUP statement for your
total price column

=VLOOKUP(A2,sheet2:$A$2:$B$100,2,false)*B2

where A2 is the item# and B2 is the quantity

Regards
JulieD