Looking up text values in a col. and replace text in another col

theorganist - Oct 1, 2015 at 05:50 AM
Hello, I am trying to lookup a partial text value in column 1(e.g. lookup all cells with the suffix AAL in cells that have an actual text of say AAL687). For those cells that match I want to change the value in another non adjacent column (say column 6) to the text value "R". The values in column 1 are NOT ascending.

Any solutions?