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

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

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