I'm trying to use the search function to search for two strings in text. That is, I have a spreadsheet whose "L" column is populated with short phrases, like "I ate a rotten orange and mango today." It could be anything. The point is I want to use the SEARCH function to find entries that mention mango OR orange. I thought I'd use something like
=SEARCH(OR("mango", "orange")$L$1:$L$250) but it isn't working. How can I adapt the SEARCH function to search for multiple strings?