If find text in column, put text in cell 5 columns over?

[nobodyukno]

So if I wanted to search Column AE for a comma "," how could I add the word "FLAG" to the same row, but 5 columns to the right when it finds a comma?

[63falcondude]

If you are interested in a formulaic solution, try this (assuming that your data starts in row 2):

AJ2 =IF(COUNTIF(AE2,"*,*"),"FLAG","")

Copy the formula down the column as far as needed.