So, I am trying to search text in 1 cell and have it return a specific text. I'd like to combine the following into 1 formula if possible.
=IFERROR(IF(SEARCH({"Head","Neck"},I3)," Head/Neck/ENT "),"Other")
=IFERROR(IF(SEARCH({"Breast","Augmentation"},I3),"Breast Reconstrcution"),"Other")
=IFERROR(IF(SEARCH({"Hernia","Abdomen"},I3),"Hernia/Abdominal Wall"),"Other")
I got to the point where I can continue to add additional words to the "Other" search.........and make it work.
=IF(COUNT(SEARCH({"Breast","Augmentation"},I2)),"Breast Reconstruction",IF(COUNT(SEARCH({"Hernia","Abdomen"},I2)),"Hernia/Abdominal Wall",IF(COUNT(SEARCH({"Head"},I2)),"Head/Neck/ENT",IF(COUNT(SEARCH({"Other","Grafting"},I2)),"Other"))))
but I would rather have it error out to "Other" somehow if the initial criteria is not found to avoid having to constantly bulk up the formula. rather not use a table.
I am open to any suggestions. Thank you.
Bookmarks