Forum Discussion
If a certain value is found in a cel, then add a certain value in the cell next to it.
Hello people from the Excel community, So I want to write certain links, which say something like for example "if "A" is found in a cel in column 2, then add "elephant" in the cell next to it (so...
Let's say the data start in B2.
If you want to see "elephant" in C2 if the value of B2 is "A", enter the following formula in C2:
=IF(B2="A","elephant","")
If you want to see "elephant" in C2 if the value of B2 contains "A" with possibly other text, use
=IF(ISNUMBER(SEARCH("A",B2)),"elephant","")
Fill down from C2 to the end of the data.