Index Match from Two Columns - Issue

I would like to match two columns and return a third.

I am pulling my hair out wondering why I can't obtain the result I want. I am extremely confident that the formula is correct but can't get the desired result. PLEASE HELP!

I have highlighted the result rows (yellow) and result cell (red). The formula required is highlighted (green).

Many thanks,

Danny