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