What is the problem with this formula?

[rachitm]

=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

 

[Guest]

Try

=IF(COUNTIF(C12:C14,"*John*"), C12&C13&C14, "None")

 

[Bill Kuunders]

try something like

"=IF(FIND(A1,CONCATENATE(C12,C13,C14))=1,CONCATENATE(C12," ",C13,"
",C14),"None")

enter in A1 John

 

[Bill Kuunders]

oops,,,

take the countif solution
it works a lot better

 

[Guest]

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

 

[rachitm]

Thank you for all your help! I just used it and it works!
Thanks a lot