Hello, I do not use Excel that often and I normally only use the basic functions but I am looking to make my life a little easier if possible. Im hoping someone can help me figure out which function I should use in my case.

The function I am looking for is one that would act like a condition statement (if x is true then a) for a range of cells, and compile a list from a different cell instead of having two outcomes (true or false).

My example:

Business Names Gold Sponsor Silver Sponsor
A Yes No
B No Yes
C Yes Yes

I have a list of businesses (A,B,& C) and two different levels of sponsors (Gold & Silver). I would like to find the function that creates a list of Business Names for each the gold and silver sponsors like below:

Gold Sponsors
A
C

Silver Sponsors
B
C



Thank you!