Formula to create a unique supplier list based on criteria

Hi,

I'm developing a tool that will output which suppliers can fulfill a requirement based on the users input.

Attached is an example of the scenario I'm working with and describes in a little more detail what I'm seeking to achieve.

If you have any questions just give me a shout.

Thanks in advance,

Snook

Apologies I must be losing it, I've already raised this query in the past.

Link

My bad.