Thanks for taking the time to read my quesiton.

I would like my formula to check one row of data and where true, return all
the values in a second row.
A B C D E F
1 Bob Judy Frank Hector Jill Betty
2 Yes No No Yes Yes No

Formula:
={IF(A2:F2="No",A1:F1,"")}

I would like to see:
Judy Frank Betty in one cell.

Can I do that?

Thanks,

Brad