Formula to evaluate a matrix and return a supplier list

Afternoon all,

I have a matrix that contains data relating to suppliers, lots and job roles they can undertake. What I need to create is a dynamic supplier list based on this criteria using drop down selectors.

Attached is an example of the data I'm working with.

If you have any queries just give me a shout.

Thanks in advance,

Snook