Aqw Amt     %
A   7500    7
A   10000   8
A   11000   9
A   12000   10
B   7500    7.5
B   10000   8.5
B   11000   9.5
B   12000   10.5

Aqw Amt %
A   7122

=INDEX(C:C, AGGREGATE(15, 6, ROW($2:$99)/((A$2:A$99=F2)*(B$2:B$9>=G2)), 1))

=INDEX(Sheet6!C2:C9,MATCH(1,(Sheet6!A2:A9=Sheet7!A2)*(Sheet6!B2:B9=Sheet7!B2),0))