I have two columns of data. One may or may not contain a certain phrase. The other has a list of companies. The plain language of what I would like to have happen is
"Look in Column K. If you find the letters "ABC" anywhere in the cell, then show "QED" in Column J. Otherwise, show me the information in column L"
Bookmarks