Here is what I am trying to do.
If column A is Max1
then look at columns B,C,D and if they contain the word Max, then change their values in column F,G to Max1
When it looks at column D, since it does not contain the word Max, the formula does not do anything to it and keeps as is in column H
Column A |Column B | Column C | Column D | Expected Result: Column E |Column F | Column G | Column H |
Max 1 Max 2 Max 3 Steve 4 Max1 Max1 Max1 Steve 4
If column A is Max1
then look at columns B,C,D and if they contain the word Max, then change their values in column F,G to Max1
When it looks at column D, since it does not contain the word Max, the formula does not do anything to it and keeps as is in column H
Column A |Column B | Column C | Column D | Expected Result: Column E |Column F | Column G | Column H |
Max 1 Max 2 Max 3 Steve 4 Max1 Max1 Max1 Steve 4