Search multiple rows with multiple conditions

[lewistsao]

Apologies if this has been asked before, but I have not been able to find anything that helps.
Let’s say I have one shee/filet of interest rates as follows

BankName, interest rate, start date, end date
BankA,1.234,01/01/2010, 15/01/2012
BankA,2.345,16/01/2012,15/02/2012
BankA,3.456,16/02/2012,31/03/2012
BankB,4.456,01/01/2010, 15/01/2012
BankB,5.678,16/01/2012,15/02/2012
BankB,6.789,16/02/2012,31/03/2012

Now I have another sheet/file, that I need to populate the interest rate

Deposit, Deposit Date,Deposit Bank,Interest
$100,10/02/2012,BankB,-searh for and pull in interest rate from other sheet/file-

where I need to replace/fill in empty cell with interest rate.
In this case I need to find 5.678 from row 5.

Many thanks

[mariosv]

With the SUMIFS() function can be done, only adapt to put it in other sheet.

[lewistsao]

Thank you very much for the solution.

Help page for SUMIFS talks about sum over a range that meet criteria. Since my criteria refers to unique row, this works.

Previously I did not understand how to use SUMIFS.

Again thank you very much. This is a great help, specially when I have thousands and thousands of rows.