I have a project that requires a formula to input a "yes or "nothing" by searching another cell for the words "Fireplace" or "Hot tub". I have figured out how to get the IFERROR function to answer "nothing" if it is not in the cell, but not sure how to get it to ssy "yes" instead of fireplace if it is in the cell it is searching.



Formula I am using :

=IFERROR(SEARCH("fireplace",B2),"")

Please help been working on this for days. Can't seem to figure it out.