Previous Topic Next Topic

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

Solved/Closed
help - 11 Oct 2011 à 18:10
 help - 11 Oct 2011 à 19:02
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

Réponse 1 / 1
help
11 Oct 2011 à 19:02
Solved, Thanks

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

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
How to format Lava mobile?
Akum -
Dushyant -

22 responses
SSL problem
Twilight -
ac3mark -

1 response
tamil word to pdf converter
GURUNATHAN -
evabrown2508 -

3 responses