Wanting to extract specific data from a table of values

Hi,

I have attached a spreadsheet which shows data on the left hand side which is automatically download via IRESS (a software program we use) and on the right hand side (highlighted in yellow) is the data I need to extract. I have tried matches, index but it seems to bring up the wrong data and not sure what I have done wrong. I would prefer a non-macro if possible but if it's not, then happy with macro.

Hope that makes sense, let me know otherwise.

Your help would be greatly appreciated.