Forum Discussion
HOW TO: "If cell contains specific text then return specific text"
I'm trying to extract a bunch of specific text combinations from cells and present them in a new cell for a database I'm working on for a dental marketing agency.
This formula comes close to working:
=IF(ISNUMBER(SEARCH("Scheduled",Y2,1)),"Scheduled",
IF(ISNUMBER(SEARCH("Not Scheduled",Y2,1)),"Not Scheduled",
IF(ISNUMBER(SEARCH("Reschedule",Y2,1)),"Reschedule",
IF(ISNUMBER(SEARCH("Cancellation",Y2,1)),"Cancellation",
IF(ISNUMBER(SEARCH("Confirmation,Y2,1)),"Confirmation",
IF(ISNUMBER(SEARCH("Attempt Schedule",Y2,1)),"Attempt Schedule",
IF(ISNUMBER(SEARCH("Attempt Reschedule",Y2,1)),"Attempt Reschedule","No Match")))))))
However, for the cells containing "Not Scheduled" - "Scheduled" is returned. For cells containing "Attempt Reschedule" - "Reschedule" is returned.
Any fix to this?
=IF(ISNUMBER(SEARCH("Not Scheduled",Y2,1)),"Not Scheduled",IF(ISNUMBER(SEARCH("Scheduled",Y2,1)),"Scheduled",IF(ISNUMBER(SEARCH("Attempt Reschedule",Y2,1)),"Attempt Reschedule",IF(ISNUMBER(SEARCH("Cancellation",Y2,1)),"Cancellation",IF(ISNUMBER(SEARCH("Confirmation",Y2,1)),"Confirmation",IF(ISNUMBER(SEARCH("Attempt Schedule",Y2,1)),"Attempt Schedule",IF(ISNUMBER(SEARCH("Reschedule",Y2,1)),"Reschedule","No Match")))))))You can try this formula which works in my sheet.
=IF(ISNUMBER(SEARCH("Not Scheduled",Y2,1)),"Not Scheduled",IF(ISNUMBER(SEARCH("Scheduled",Y2,1)),"Scheduled",IF(ISNUMBER(SEARCH("Attempt Reschedule",Y2,1)),"Attempt Reschedule",IF(ISNUMBER(SEARCH("Cancellation",Y2,1)),"Cancellation",IF(ISNUMBER(SEARCH("Confirmation",Y2,1)),"Confirmation",IF(ISNUMBER(SEARCH("Attempt Schedule",Y2,1)),"Attempt Schedule",IF(ISNUMBER(SEARCH("Reschedule",Y2,1)),"Reschedule","No Match")))))))
2 Replies
=IF(ISNUMBER(SEARCH("Not Scheduled",Y2,1)),"Not Scheduled",IF(ISNUMBER(SEARCH("Scheduled",Y2,1)),"Scheduled",IF(ISNUMBER(SEARCH("Attempt Reschedule",Y2,1)),"Attempt Reschedule",IF(ISNUMBER(SEARCH("Cancellation",Y2,1)),"Cancellation",IF(ISNUMBER(SEARCH("Confirmation",Y2,1)),"Confirmation",IF(ISNUMBER(SEARCH("Attempt Schedule",Y2,1)),"Attempt Schedule",IF(ISNUMBER(SEARCH("Reschedule",Y2,1)),"Reschedule","No Match")))))))You can try this formula which works in my sheet.
=IF(ISNUMBER(SEARCH("Not Scheduled",Y2,1)),"Not Scheduled",IF(ISNUMBER(SEARCH("Scheduled",Y2,1)),"Scheduled",IF(ISNUMBER(SEARCH("Attempt Reschedule",Y2,1)),"Attempt Reschedule",IF(ISNUMBER(SEARCH("Cancellation",Y2,1)),"Cancellation",IF(ISNUMBER(SEARCH("Confirmation",Y2,1)),"Confirmation",IF(ISNUMBER(SEARCH("Attempt Schedule",Y2,1)),"Attempt Schedule",IF(ISNUMBER(SEARCH("Reschedule",Y2,1)),"Reschedule","No Match")))))))
- Worked. Thanks!
