Index match not returning the desired result - help appreciated

Sample workbook attached. Data, my attempt at solving, and the desired result.

I've been wrestling with this for ages and just can't get it to do what I'd like, after trying all sorts of formula's I'm here asking for help.

Thanks

Hi Debraj,

Thanks, your formula revision seems to be working on the limited data set.

I've uploaded another sample workbook with a larger dataset as you have requested, you will see what I'm attempting to achieve.

Thank you for taking the time to help.

Hi Debraj,

Thanks very much for taking the time to help me.
With your assistance I've now managed to solve these issues I've been wrestling with for weeks. I've adjusted your formula to take account of the increased data set and the different timings I use in the supporting data sheet, all is working perfectly now.

I'll mark the thread as solved and add to your reputation.