Use array to return array of values

B

Brad

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
 
R

renegan

Try this:

=IF(A2:F2="No",A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1,"")

Assuming you want a space between the names. If not jus put & betwee
cell names
 
Top