|
|
IF_ISNUMBER_FIND Single value =IF(ISNUMBER(FIND("text to find",within cell or range eg A1)),"THERE","NOT THERE") Multiple values - maximum of 6 =IF(ISNUMBER(FIND("one",A1,1)),101,IF(ISNUMBER(FIND("two",A1,1)),102,IF(ISNUMBER(FIND("three",A1,1)),103,IF(ISNUMBER(FIND("four",A1,1)),104,IF(ISNUMBER(FIND("five",A1,1)),105,IF(ISNUMBER(FIND("six",A1,1)),106,0)))))) |