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

- - Latest reply:  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
See more 

1 reply

Best answer
2
Thank you
Solved, Thanks

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

Say "Thank you" 2

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

CCM 5735 users have said thank you to us this month