Three Variable Match / Index (With different column headings)

Hi there,

This is an extension of a previous thread where someone kindly help me do a 2 variable match formula. I now was wondering if a 3rd variable could be added?
In the attached sheet, it all works until you change the "Actual" drop down in N4, it then returns errors.

What I am trying to achieve is to have a ranking of all the variables for example rank by TAX, ACTUAL if the region is "BG".

If anyone knows what is wrong with my array formula in column M that would be a great help.

Thanks,

Sam

Thank you very much for your reply, I have reattached the updated version.

Please could you let me know if it is possible to have the second variable as an optional rank? E.g. how can I see the whole list ranked by sales actual?
At the moment I have to choose a region, but is there a way I can "Select All" or something similar?
I hope I'm making sense!!

Sam