View Single Post
 
Old 09-29-2017, 07:19 AM
BrookeJ239 BrookeJ239 is offline Mac OS X Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
BrookeJ239 is on a distinguished road
Default Using IFERROR & FIND Function

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.
Reply With Quote