Running through a column in excel and removing certain text based on a vlookup : <p>I apologize in advance if this is trivial but I am struggling to remember the syntax for visual basic as it has been so long.</p>

<p>I have text in cells in column D that needs removing (Country names). I have a separate sheet that contains all the Country names and so I thought I could run through the column cell by cell and check whether there were any cells whose text matched that of the country table I have on a separate sheet. (I.e. a vlookup which changed the text if it matched to something like 'deletME')</p>

<p>Thanks!</p>
