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

  • Thread starter Thread starter destiny
  • Start date Start date
D

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