Hi,
Please see sample spreadsheet. I'm looking for a function that would:
A) Search the data in column A for the words, TREAS, DFAS, DCD, PAY (There are more, but I assume I could add them later)
B) If the data in a cell in column A contains any of these words, put, "FED" in adjacent cell in B column. If the data does not contain any of those words, put, "Non-Fed", in adjacent cell in B column.
Thanks in advance,
- Jim
Bookmarks