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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set cell value if adjecent cell value is greater than 0 2
Max Price and Min Price paid for an item - Rephrsed 4
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Max Price and Min Price paid for an item 1
IF and Vlookup 1
Compare to two sheets in one excel file to evaluate and combine whereidentical. 1
SUMPRODUCT Help 4
Add values based on text color with the criteria of a date 7

Back
Top