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

help - Oct 11, 2011 at 06:10 PM - 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,"")

Thank you, help 2

Something to say? Add comment

CCM has helped 1900 users this month