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

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))

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!

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

You're welcome. Happy to help.

Thanks for the rep!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1