if cell contains any of the entries in a column, insert specific text in neighboring cell

Hi Rob,

You should really start a new thread and post a sample workbook. You can attach a link to this post if you think it helps. That way we can work on current problems instead of questions from 3 years ago.