I need to Search for text within a cell and returning value based on what is found or leave the cell blank if neither is found. Hello, I need to amend this example formula so if cell C3 finds “apple” that the value $1 is returned, but if it finds “orange” that the value is $2 and if neither word is in cell C3 that a blank is returned. =IF(OR(ISNUMBER(SEARCH(“apple”,C3)),ISNUMBER(SEARCH(“apple”,C3))),”1″,””)

​I need to Search for text within a cell and returning value based on what is found or leave the cell blank if neither is found. Hello, I need to amend this example formula so if cell C3 finds “apple” that the value $1 is returned, but if it finds “orange” that the value is $2 and if neither word is in cell C3 that a blank is returned. =IF(OR(ISNUMBER(SEARCH(“apple”,C3)),ISNUMBER(SEARCH(“apple”,C3))),”1″,””)  Read More

​