I have this formula that uses one search function to do multiple searches.
The formula is
Formula:![]()
=SMALL(IF(SUMPRODUCT(NOT(ISERR(SEARCH({"house","tent","zebra"},B1:B4)))*{1,2,4})=7=TRUE,ROW(B1:B4)),1)
but I'm getting an error message.
The answer I want is 2 (row 2) since all the matches occur there.HTML Code:
What is wrong with the formula?
Bookmarks