Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
About Fuctions
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
About Fuctions
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Nested If Fuctions | Excel Worksheet Functions | |||
Using Worksheet Fuctions with Macros | Excel Discussion (Misc queries) | |||
Equalls fuctions | Excel Worksheet Functions | |||
unrecognized fuctions evapp etc | Excel Worksheet Functions |