CHALLENGE - Extract data from a table with multiple conditions....

Hello,

I have added the sample table to the attached.

Tried to add my sample formulas and give a breakdown of what is required. i.e. the yellow cell at the top denotes the correct value which should be pulled through from the bottom table.

I always want the table to pull through the TOTAL figure so this needs to be looked up as a third parameter.

Thanks