Search and Return a List

[Twolf15]

I have a excel spreadsheet that looks something like this:
Name.....Stuff 1..... Stuff 2..... Stuff 3
Dude 1 .....X.............................X
Dude 2 .....................X
Dude 3 .....X..............X.............X
Dude 4 ....................................X

So I have sheets for Stuff 1, Stuff 2 and Stuff 3

I need the sheets for stuff to list who does NOT have an X in the
column for each stuff

So the sheet for Stuff 1 should list Dude 2 and Dude 4. Stuff 2 should
list Dude 1 and Dude 4. Stuff 3 should list Dude 2. Get it?

My actual workbook has 150 names on it, but I think that my example shows what I need it to do.

I thought VLOOKUP would do the trick, but apparently now.

Any suggestions?

-Twolf

 

[Twolf15]

You are brilliant!!!!!!