=IF(ISNUMBER(MATCH("*John*",C12:C14,0)),C12&" "&C13&" "&C14,"None")


" wrote:

=IF(FIND("John", C12:C14, 1), C12:C14, "None")

Could anyone help me out with what the issue is with the above formula?
Whenever I enter the above formula in a cell, it gives me a #VALUE
error. I just want to find if there is John written in cells C12 thru
C14, and if there is, I want it to type all the info from cells C12
thru C14 on another cell.

All help is appreciated! Thank you