Im trying to create a list of names from a range based on two variables, while also eliminating duplicate results or blank spaces. For example, if i want to know who has apples OR oranges:

Huey Apples
Dewey Pears
Louie Oranges

Should return:

Huey
Louie

I think a INDEX MATCH in combination with an if/or should work, but I can't seem to put it together correctly....

Thanks!