If A1 contains the a word, then show B2 in C2

Solved/Closed
help - Oct 11, 2011 at 06:10 PM
 help - Oct 11, 2011 at 07:02 PM
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
Related:

1 response

Solved, Thanks

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