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

%3CLINGO-SUB%20id%3D%22lingo-sub-2153783%22%20slang%3D%22en-US%22%3EIf%20a%20certain%20value%20is%20found%20in%20a%20cel%2C%20then%20add%20a%20certain%20value%20in%20the%20cell%20next%20to%20it.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153783%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20people%20from%20the%20Excel%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20want%20to%20write%20certain%20links%2C%20which%20say%20something%20like%20for%20example%20%22if%20%22A%22%20is%20found%20in%20a%20cel%20in%20column%202%2C%20then%20add%20%22elephant%22%20in%20the%20cell%20next%20to%20it%20(so%20in%20column%203)%22.%20That%20way%20anytime%20their%20is%20a%20certain%20value%20found%20in%20a%20cell%20in%20a%20column%2C%20another%20certain%20value%20will%20be%20added%20in%20the%20cell%20in%20the%20column%20next%20to%20it.%20Can%20anybody%20please%20help%20me%20with%20this%3F%20Or%20think%20of%20a%20solution%20for%20the%20problem%20which%20gives%20the%20same%20result%2C%20so%20also%20solves%20the%20problem%3F%20I%20would%20be%20very%20grateful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2153783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

@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.