I have 4 possible entries for a cell per row depending on a filename in column A. I wanted to use an IF statement with SEARCH and wildcards:
IF(SEARCH("*x*",A1),"Text to return to field if true", IF(SEARCH...etc.
If I end the statement with a value_if_true field and a value_if_false field, the search works and the cell is populated with the text I want. But if I add another IF statement as my value_if_false field, Excel cannot compute even the first search. Any ideas on this?