VLOOKUP

[Learningfast]

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

 

[carlo]

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