Forum Discussion

TJ_Excel_Newbie's avatar
TJ_Excel_Newbie
Copper Contributor
Oct 04, 2022
Solved

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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 04, 2022

    TJ_Excel_Newbie 

    =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")))))))

     


     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 04, 2022

TJ_Excel_Newbie 

=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")))))))

 


 

TJ_Excel_Newbie's avatar
TJ_Excel_Newbie
Copper Contributor
Oct 04, 2022
Worked. Thanks!

Resources