Caculating Sales using If(vlookup())

[Gregc.]

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

[Greg]

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
>
>

[Gregc.]

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