# [Formula] Lookup based on two range values

1. ## [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

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.  Register To Reply

2. ## Re: [Formula] Lookup based on two range values

Try this in C2:

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

3. ## Re: [Formula] Lookup based on two range values 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!  Register To Reply

4. ## Re: [Formula] Lookup based on two range values

You're welcome. Happy to help.

Thanks for the rep!  Register To Reply