VLOOKUP
 

Hi:
The dataset for the vllokup contains many rows with the same reference: Ex

Coupon # Transaction Sales
1 5 $ 10
2 7 $3
1 3 $15

When I write =vlookup(A3,"SheetName" $A;$E, 2,0) I only get one number for
each unique coupon # instead of a sum of all coupon numbers.
Can you help?
Thanks.
Heather

VLOOKUP
 

Hi Heather

what exactly do you want as output?
1 8 $25
then you would do following (assuming that you're first row is a
header)
=SUMIF(Sheet1!$A$2:$A$4,$A8,Sheet1!$B$2:$B$4)

which you can then drag to the right side, and then drag down.

hth
Carlo

On Jan 16, 1:47*pm, Learningfast
wrote:
Hi:
The dataset for the vllokup contains many rows with the same reference: *Ex

Coupon * # * * * * * * Transaction * * * * * * * * *Sales
1 * * * * * * * * * * * * *5 * * * * * * * * * * * * * * * *$ 10
2 * * * * * * * * * * * * *7 * * * * * * * * * * * * * * * * *$3
1 * * * * * * * * * * * * *3 * * * * * * * * * * * * * * * * * $15

When I write =vlookup(A3,"SheetName" $A;$E, 2,0) I only get one number for
each unique coupon # instead of a sum of all coupon numbers.
Can you help?
Thanks.
Heather