Index Match Array Multiple Criteria

[Keelin]

Hi All,

I am having issues with a multiple criteria index match array!

I have attached an example where I need to bring back a result matching 4 specific criteria, but I cannot seem to get it to work at all!

I have attached an example dataset with the formula that I was trying to get right (and failing miserably!!)

Any and all help would be greatly appreciated

Thanks so much in advance all

Keelin