Array Formula - Index / Match - Dedupe & filter criteria

Hello Excel community!

I have spent almost a week and been to dozens of sites trying to figure out a formula that I'm sure would take some of you only a few minutes to complete.

The objective:
Get unique values from one column then filter it further by a second column.

The current formula in B2:B8 is an array formula (below) that indexes and dedupes the list in column D:

Formula:

Please Login or Register  to view this content.

Attached Example XLSX: ArrayFormula-Test.xlsx


What I'm looking for now is to take the deduped list and then check to see if any of the values are in a second list in Column F where there is an "X" in Column G and filter those results out.

Screenshot of the above Excel Attachment: Screenshot 2014-05-28 10.37.31.png

I'm not sure if this is a nested IF statement or another Index/Match or a CountIF. I can do these functions separately but need it within a single array formula.

Any help would be greatly appreciated.

Thank you.

Ace's response was great and it does filter results from Column F that have an "x" in column G.

If anyone can help me combine this with the deduping of the results from Column D, I'd be greatly appreciative.

Maybe this should help you out, please have a look the file attach....

Thanks
Azumi

This is EXACTLY what I was looking for. Thank you so much to ACE and Azumi for helping with this:

The solution was the array formula:

Formula:

Please Login or Register  to view this content.

Yes you're welcome, thanks for the feedback