[Formula] Lookup based on two range values

Example.png

Hi, I got a semi hard one today :D

I have two columns with amounts and percentages and a third column for my return values.

I have a chart with a header range of:

0-60.00
60.01-65.00
65.01-70.00
70.01-75.00
75.01-80.00
80.01-85.01

..and header row of:

10000-34999
35000-49999
50000-74999
75000-99999
100000-150000
150001-350000
350001-500000
500001>

What I want to do is have a formula identify the amount in cell A2 and percentage in B2 and find the intersection value in the two ranges.

Try this in C2:

=INDEX(F$3:L$10,MATCH(A2,E$3:E$10,1),MATCH(B2,F$2:L$2,1))

Originally Posted by 63falcondude

Try this in C2:

=INDEX(F$3:L$10,MATCH(A2,E$3:E$10,1),MATCH(B2,F$2:L$2,1))

Thank you so much! You rock!

You're welcome. Happy to help.

Thanks for the rep!