G
Guest
Sheet 1 is a summary sheet that looks like -
Sales Person Commission
1 14 $4,500.00
2 15 $2,580.00
3 16 $1,533.00
4 22 $1,500.00
5 25 $0.00
Sheet 2 looks something like -
Salesperson Product Commission
1 14 GlasBu 1500.00
2 14 GlasBu 1500.00
3 22 ThiHy 1500.00
4 14 GlasBu 1500.00
What I am looking for is a formula for Sheet 1 that looks at A1 and then
looks at Sheet 2 A1 and everytime the numbers match, cumlatively adds the
amount in Sheet 2 C1.
Hope this make sense and I really appreciate your help.
Sales Person Commission
1 14 $4,500.00
2 15 $2,580.00
3 16 $1,533.00
4 22 $1,500.00
5 25 $0.00
Sheet 2 looks something like -
Salesperson Product Commission
1 14 GlasBu 1500.00
2 14 GlasBu 1500.00
3 22 ThiHy 1500.00
4 14 GlasBu 1500.00
What I am looking for is a formula for Sheet 1 that looks at A1 and then
looks at Sheet 2 A1 and everytime the numbers match, cumlatively adds the
amount in Sheet 2 C1.
Hope this make sense and I really appreciate your help.