Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caculating Sales using If(vlookup())
G'day
I am trying to calculate the sales figure for an organisation using if(vlookup). What I am trying to do is lookup the item in the Item information part of the sheet, compare it with the item in the order information part of the sheet, and if there is a match, then multiplu the sales price by the qty. Would anyone have any ideas? Thanks for your help Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caculating Sales using If(vlookup())
Hi,
Lookes like this question should be in a Functions group. Why can't you lookup the sale price ? Say items are in Col A, Quantity in Col b , so in C lookup the price for each item and then in col D do B2*C2. If the items are not unique you could get subtotals by using Sumif or better yet Sumproduct functions (search functions group). HTH, if not post back. -- ______ Regards, Greg "Gregc." wrote: G'day I am trying to calculate the sales figure for an organisation using if(vlookup). What I am trying to do is lookup the item in the Item information part of the sheet, compare it with the item in the order information part of the sheet, and if there is a match, then multiplu the sales price by the qty. Would anyone have any ideas? Thanks for your help Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Caculating Sales using If(vlookup())
Greg wrote: Hi, Lookes like this question should be in a Functions group. Why can't you lookup the sale price ? Say items are in Col A, Quantity in Col b , so in C lookup the price for each item and then in col D do B2*C2. If the items are not unique you could get subtotals by using Sumif or better yet Sumproduct functions (search functions group). Never knew that a functions group existed until now. Thanks for you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Caculating the remainding amount | New Users to Excel | |||
Workbook not caculating formulas | Excel Discussion (Misc queries) | |||
Caculating Columns Between Certain Dates | New Users to Excel | |||
Caculating a "staircase" discount | Excel Worksheet Functions | |||
I need help Caculating Zip code Distances | Excel Programming |