Using IF formula to return a List

Hi Everyone,

I'm not sure if the following is possible, but here goes...

On the attached I am wanting to make a list of people who are first aid trained based, which is highlighted in Column B 15-22. The list would then be returned in Cells A3-6. On the example attached in cell A3-6 the names Richard, David, Mel and Mark would be listed.

Is there a formula that would do this? I thought maybe an IF formula?

Try

=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$9="Yes",ROW($B$2:$B$9)),ROWS($1:1))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

See attached.

Awesome! Spot on... it worked

Is there a way to list the names along a row instead of column at all?