software

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=quot;Noquot;,A1:F1,quot;quot;)}

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

Can I do that?

Thanks,

Brad


Try this:

=IF(A2:F2=quot;Noquot;,A1amp;quot; quot;amp;B1amp;quot; quot;amp;C1amp;quot; quot;amp;D1amp;quot; quot;amp;E1amp;quot; quot;amp;F1,quot;quot;)

Assuming you want a space between the names. If not jus put amp; between
cell names.--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528176Awesome! Thank you very much.

Brad

quot;reneganquot; wrote:

gt;
gt; Try this:
gt;
gt; =IF(A2:F2=quot;Noquot;,A1amp;quot; quot;amp;B1amp;quot; quot;amp;C1amp;quot; quot;amp;D1amp;quot; quot;amp;E1amp;quot; quot;amp;F1,quot;quot;)
gt;
gt; Assuming you want a space between the names. If not jus put amp; between
gt; cell names.
gt;
gt;
gt; --
gt; renegan
gt; ------------------------------------------------------------------------
gt; renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
gt; View this thread: www.excelforum.com/showthread...hreadid=528176
gt;
gt;