I need a formula to accomplish the following:
Column A contains an alphanumeric string up to 50 characters in length. I need a formula to search the string in Column A for the word "Appeal" and place that word in Column B when found. Likewise for the words "Grievance" and "Complaint". If none of the three words are found in Column A, the contents of Column B should be blank.
Here's the formula I've played around with (it works on the first line but returns #VALUE! on following lines):
=IF(SEARCH("Appeal",A1),"Appeal",IF(SEARCH("Grievance",A1),"Grievance",IF(SEARCH("Complaint",A1),"Complaint","")))
I've tried entering it as an array, but that also fails.
This seems like a pretty simple problem ,but I've spent several hours trying to make the formula work so I'm obviously doing something wrong. I'd appreciate any guidance you can provide.
Bookmarks