Need to match 2 cells (ID & Date) in 1 spreadsheet to cells in another spreadsheet

[Kimchee287]

I need to match the ID and Date from the Expenses tab and find a matching row in the Hotel Rates tab. The Date in the Expenses tab can fall between the Check in Date and Check out Date of the Hotel Rates tab.

Basically I'm looking to say if Expenses B2 matches any cell in Hotel Rates column B and Expenses C2 matches any date ranges between Hotel Rates columns C and D, then it's a match. I have attached the sample file.

[drstrings]

Try This:
=IF(ISNUMBER(MATCH($B2,'Hotel Rates'!$B$2:$B$4,0)),IF(AND(INDEX('Hotel Rates'!$C$2:$C$4,MATCH($B2,'Hotel Rates'!$B$2:$B$4,0))<=Expenses!$C2,INDEX('Hotel Rates'!$D$2:$D$4,MATCH($B2,'Hotel Rates'!$B$2:$B$4,0))>=Expenses!$C2),"Match","No Match"),"No Match")

[FDibbins]

If I understand you correctly, try this, copied down...
=IF(SUMIFS('Hotel Rates'!$E$2:$E$4,'Hotel Rates'!$A$2:$A$4,Expenses!A2,'Hotel Rates'!$C$2:$C$4,"<="&Expenses!C2,'Hotel Rates'!$D$2:$D$4,">="&Expenses!C2)>0,"Match","No Match")

[Kimchee287]

This formula is the one that worked for me! Thanks so much for your help!

=IF(SUMIFS('Hotel Rates'!$E$2:$E$4,'Hotel Rates'!$A$2:$A$4,Expenses!A2,'Hotel Rates'!$C$2:$C$4,"<="&Expenses!C2,'Hotel Rates'!$D$2:$D$4,">="&Expenses!C2)>0,"Match","No Match")

[FDibbins]

Happy to help and thanks for the feedback