Formula to evaluate criteria across two matrices

[The_Snook]

Evening all,

I've been given two matrices, one defining which services a supplier can undertake and the other which regions they operate in. I need to create a document that can be used to identify which suppliers are capable of undertaking a requirement based on the criteria selected (services and regions).

Attached is an example of the data I'm working with along with a tab showing the output required.

If you require any further info just give me a shout.

Thanks in advance,

Snook