Index + Multiple Match Conditions??

Hi everyone

I have found this Forum really great as it has encouraged me to try and do much more than I have done in the past with Excel. Despite buying a few books and searching through various Excel support sites, I still seem to come unstuck at some point.

My latest problem is best seen by viewing the REMOVED worksheet in the attached workbook.

I am trying to create a formula that will generate the total from row 10 in the COLLECT column according to the date shown in D12.

As can be seen from the result in D13, I have managed to use INDEX and MATCH to extract the first occurrence of the Totals figure (L10) within the worksheet, using a defined range (Table). However, no matter how many ways I try to combine an additional MATCH with the date (D12) and Row 2, nothing works or produces the correct result.

Although the test cells are located on the REMOVED worksheet; they will actually be located on different worksheets but it seemed to locate them on the same worksheet for testing.

Hopefully, there will be someone who knows the answer to this one.

Thanks in advance …Spellbound