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