If A1 contains the a word, then show B2 in C2 [Solved/Closed]

Report
-
 help -
Hello,

I'm trying to create a formula to display the contents of B2 in C2 if cell A2 has a certain word.
ex. =IF(ISNUMBER(SEARCH("BACH",B13)),"=C13")

Thanks

1 reply

Solved, Thanks

=IF(ISNUMBER(FIND("*",A2)),B2,"")
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3482 users have said thank you to us this month