Countif returning a column value or values

[jwah]

The basis of this is a COUNTIF but I want to return the contents of Column A when there was a match.

I have an array I2:Q80 and everytime I find a match return the string in Column A.

The countif(i2:q80,"hello") would let's say... equal 3

and the cell containing the formula would contain "ABC, DEF, HIJ"

(I would like commas too )

 

[mikerickson]

This might help.
http://www.mrexcel.com/forum/showthread.php?t=570828&highlight=ConcatIf

 

[jwah]

Thanks. Before I go the VBA way.... Any chance to get a Forumula within a cell?

 

[T. Valko]

Thanks. Before I go the VBA way.... Any chance to get a Forumula within a cell?

Not very practical if there are more than 2 or 3 matches. The resulting formula would be extremely long.