Hi All:
I have a formula that I am working to tweak to search for multiple text.
- I want to look in a table for specific texts. Example: "Pol", "Occl", "Hap", and "Div"
- If the texts are found anywhere in the searched cells, I want the entire cell data returned.
This is the formula that is working for me for just 1 search criteria. For example:
ARRAY FORMULA =Iferror(Index($G1:$AZ1,Small(If(IsNumber(Search("Pol",$G15:$AZ15)),Column($A$2:$AH$2)-Row($A$1)+1,Column($A$1))),"")
I have tried putting "OR" after the iferror and dropping in the different specific texts...it bombs.
Any help would be appreciated!
Thanks
Bookmarks