Use array to return array of values
 

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

Use array to return array of values
 

Try this:

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

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528176

Use array to return array of values
 

Awesome! Thank you very much.

Brad

"renegan" wrote:


Try this:

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

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528176