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

Occasional Visitor

# 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

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

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.