About Fuctions

  • Thread starter Thread starter Excel Worksheet Functions
  • Start date Start date
E

Excel Worksheet Functions

I am trying to function on excel about,
Sheet1
Item Price

Sheet2
Product Name Quantity Unit cost

Product Name (Combo Box) list of Item From Sheet1 Items. What i will like to
do is, when i choose under Product Name any item from Sheet1, Unit Cost is
calculating automatically From Sheet1 Item Price times Quantity.

Thank you very much for your help....
 
To pull-out the price in Sheet2's col C based on item selected in A2,
you could use in C2: =IF(A2="",0,VLOOKUP(A2,Sheet1!A:B,2,0))
assuming source table is contained in Sheet1's cols A and B

Just multiply the above by the quantity in col B
if you want to calc the "Total Cost" instead:
=IF(A2="",0,VLOOKUP(A2,Sheet1!A:B,2,0)*B2)
 
Back
Top