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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Excel Worksheet Functions" wrote:
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....