Index Small Formula?

I have two files that I need to read from each other

The first file is the database and the second file will be the query file

I have multiple Bill Month Dates that have the same BM Begin Date and same BM End Date
I want pull (1) BM Begin Date and (1) BM End Date and place on the summary based on the site and Bill Month. The summary file is by Bill Month so at the top I will indicate the Bill Month I am looking to query.

I am really not quite sure how to achieve this, I was thinking a index small formula might work but it is not.
Capture.JPGCapture2.JPG

In D5, try this:

=INDEX('DB '!C$2:C$15,MATCH($C$1&$A5,'DB '!$B$2:$B$15&'DB '!$A$2:$A$15+0,0)) Ctrl Shift Enter

Drag the formula to the right and down.

Alkey,

That's good to know. I use INDEX MATCH for multiple matches regularly so this will help.
I just have to get used to doing it this way to avoid the array.

Thanks for that.