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 in column 3)". That way anytime their is a certain value found in a cell in a column, another certain value will be added in the cell in the column next to it. Can anybody please help me with this? Or think of a solution for the problem which gives the same result, so also solves the problem? I would be very grateful.
Kind regards,
Peter
1 Reply
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.
