I want to make this formula work but i think i have the wrong syntax - can anyone help?
Basically I want it to look at cell b2 and if it contains specific text return the correct value.
=OR(IF(ISNUMBER(SEARCH("ows",B2)),"OWOSSO","error"),(IF(ISNUMBER(SEARCH("sag",B2)),"SAGINAW","error"),IF(ISNUMBER(SEARCH("DAV",B2)),"DAVISON","error"),IF(ISNUMBER(SEARCH("BAY",B2)),"BAY CITY","error"),IF(ISNUMBER(SEARCH("MON",B2)),"MONROE","error"),IF(ISNUMBER(SEARCH("WHI",B2)),"WHITMORELAKE","error")))
Basically I want it to look at cell b2 and if it contains specific text return the correct value.
=OR(IF(ISNUMBER(SEARCH("ows",B2)),"OWOSSO","error"),(IF(ISNUMBER(SEARCH("sag",B2)),"SAGINAW","error"),IF(ISNUMBER(SEARCH("DAV",B2)),"DAVISON","error"),IF(ISNUMBER(SEARCH("BAY",B2)),"BAY CITY","error"),IF(ISNUMBER(SEARCH("MON",B2)),"MONROE","error"),IF(ISNUMBER(SEARCH("WHI",B2)),"WHITMORELAKE","error")))