Previous Topic Next Topic

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

Answer 1 / 1
help
Oct 11, 2011 at 07:02 PM
Solved, Thanks

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

Similar discussions

Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
lava hard reset & factory reset
AVAY -
Har -

3 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

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

22 responses
lava gem
deepak -
HelpiOS -

1 response