Hi,

My task is to find if a row contains a certain word in the X column. However
the entries in column X are strings. To solve this, in a blank column (column
AB), I used an IF formula to return a 'yes' or 'no' dependant on whether it
found the word in column X.

From this result I now need to alter the values in columns D and G if a
'Yes' is found in the new column, AB (i.e Column X contains the word I want
to find.) Otherwise, if a 'no' is found in AB then nothing is changed. I
realise that I could use a VLOOKUP formula but this would change the rows if
a 'no' was found, which I dont want it to do.

Any help would be much appreciated