Vlookup with 2 Conditions
 

I am trying to figure out how to perform a Vlookup with 2 Conditions.

In sheet1 I have a rate table similar to the following:
Col A Col B Col C
0.01 2,500.00 16.95%
2,500.01 5,000.00 15.95%
5,000.01 12,000.00 14.45%
12,000.01 20,000.00 11.75%
20,000.01 50,000.00 9.75%

On Sheet 2, I have dollar amounts in column A. If the amount in A is
greater than or equal to Sheet1!A AND Less than or Equal to Sheet1!B, I want
to return the value in Sheet!1C.

Can someone please advise on the best way to write this formula?

Vlookup with 2 Conditions
 

That can be done with a simple Vlookup using closest match

=vlookup(A1, Sheet1!$A$2:$C$6, 3, true)

or with index match

=INDEX(Sheet1!$C$2:$C$6, MATCH(A1, Sheet1!$A$2:$A$6, 1))

Where your value is in A1 on sheet2
--
HTH...

Jim Thomlinson


"Kathy - Lovullo" wrote:

I am trying to figure out how to perform a Vlookup with 2 Conditions.

In sheet1 I have a rate table similar to the following:
Col A Col B Col C
0.01 2,500.00 16.95%
2,500.01 5,000.00 15.95%
5,000.01 12,000.00 14.45%
12,000.01 20,000.00 11.75%
20,000.01 50,000.00 9.75%

On Sheet 2, I have dollar amounts in column A. If the amount in A is
greater than or equal to Sheet1!A AND Less than or Equal to Sheet1!B, I want
to return the value in Sheet!1C.

Can someone please advise on the best way to write this formula?

Vlookup with 2 Conditions
 

Try this:

=IF(AND(Sheet2!A1=Sheet1!A1,Sheet2!A1<=Sheet1!B1) ,Sheet1!C1,"")

--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"Kathy - Lovullo" wrote:

I am trying to figure out how to perform a Vlookup with 2 Conditions.

In sheet1 I have a rate table similar to the following:
Col A Col B Col C
0.01 2,500.00 16.95%
2,500.01 5,000.00 15.95%
5,000.01 12,000.00 14.45%
12,000.01 20,000.00 11.75%
20,000.01 50,000.00 9.75%

On Sheet 2, I have dollar amounts in column A. If the amount in A is
greater than or equal to Sheet1!A AND Less than or Equal to Sheet1!B, I want
to return the value in Sheet!1C.

Can someone please advise on the best way to write this formula?