Thread: Match multiple citeria to multiple results

I have attached a spreadsheet (with an explanation) as this gets a little messy. But essentially, I need to compare 3 search criterias and return all the results which cross reference against all 3 criteria.

I have tried various combinations using arrays with INDEX and MATCH, but no luck so far.

Bump no response.

The real problem I seem to be having here (still) is that I am looking at criteria in 2 columns, and then checking against values (headers) at the top of other columns. Can't crack this... Any ideas?

Seems to be the same thing I'm dealing with. (See my newest thread).