VLookup multiple columns

Hello,

I hope someone can help me quick. I have a spreadsheet that looks like the following:


Loan Type Interest Rate Base
conf20 5.375% This is what I am trying to find
conf20 5.25 %
conf20 5.63 %

Then I have another tab that has the following:

Loan Type Int Rate Base
Conf20 5.375% 7.97
Conf20 4.63% 7.48
Conf20 4.75% 7.27
Conf20 4.88% 7.06

So I need to transfer the base info from one tab to the other depending on the loan type and the interest rate on tab 2. I know I have to use Vlookup and If but I can't get it to come out. Please Help!!!!

Assuming that Sheet2 contains the source table, and that the first row contains your headers...

Sheet1!C2, copied down:

=INDEX(Sheet2!$C$2:$C$5,MATCH(1,(Sheet2!$A$2:$A$5=Sheet1!A2)*(Sheet2!$B$2:$B$5=Sheet1!B2),0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

Originally Posted by lacosta

Hello,

I hope someone can help me quick. I have a spreadsheet that looks like the following:


Loan Type Interest Rate Base
conf20 5.375% This is what I am trying to find
conf20 5.25 %
conf20 5.63 %

Then I have another tab that has the following:

Loan Type Int Rate Base
Conf20 5.375% 7.97
Conf20 4.63% 7.48
Conf20 4.75% 7.27
Conf20 4.88% 7.06

So I need to transfer the base info from one tab to the other depending on the loan type and the interest rate on tab 2. I know I have to use Vlookup and If but I can't get it to come out. Please Help!!!!