Populate Cell based on IF SEARCH() criteria in Different Cell

[Human]

First off, apologies if this is already a solved issue somewhere on the forum. This is my first time using the forum and I have not had luck finding this issue addressed in my search of it so far.

My question is how to populate a cell if a value of another cell contains a specific text, and, if it does not, I want to populate a cell X columns from the one that contains the if statement.


The logic i'm trying to capture is:

if Col1R1 contains "J", then Col2R2=Col1R1, else Col4R2=Col1R1

I've tried using offset(), but have not had luck.

When I use if(search("Text",CellX,1),CellX,CellY=CellX) It does not recognize the else statement. I feel this should work (could be wrong) but I'm not able to solve thus far.

Again apologies if there is a previous thread regarding this. Haven't been able to find it.