If Column A contains MAHESH and then in Column B the word starts with A or B then replace

[Hearnest]

Hi Team I'm trying to resolve below scenario please help

If Column A contains MAHESH and then in Column B the word starts with A or B then replace with VIGNESH

[Deano478 · Accepted solution]

hey @Hearnest you can give

IF Contains([Column A], "MAHESH") AND (StartsWith([Column B], "A") OR StartsWith([Column B], "B")) THEN "VIGNESH" ELSE [Column B] ENDIF

the following formula a try

[Hearnest]

Hi deano478, 

This worked perfectly... ! Thanks Much...

Also within same formula can we add an extended condition if column A contains name RAMESH then in Column B the first letter of the word starts with "A to H alphabet then it should replace with SUMESH

Can you help with this as well

[Deano478 · Accepted solution]

@Hearnest give this a try it should work

IF Contains([Column A], "MAHESH") AND (StartsWith([Column B], "A") OR StartsWith([Column B], "B")) THEN "VIGNESH" ELSEIF Contains([Column A], "RAMESH") AND (StartsWith([Column B], "A") OR StartsWith([Column B], "B") OR StartsWith([Column B], "C") OR StartsWith([Column B], "D") OR StartsWith([Column B], "E") OR StartsWith([Column B], "F") OR StartsWith([Column B], "G") OR StartsWith([Column B], "H")) THEN "SUMESH"
ELSE [Column B] 
ENDIF

[Hearnest]

Thank you ! it worked ...

[Sameer113]

Hi @Hearnest

You can use this:

IF CONTAINS([Column A], "MAHESH") AND (Left([Column B],1) = "A' OR Left([Column B],1) = "B")) THEN "VIGESH" ELSE [Column B]

ENDIF