If a certain value is found in a cel, then add a certain value in the cell next to it.

[Peter0182]

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

[#2]

@Peter0182 

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.