Search two or more non-consecutive words in a work sheet or column

[Excel_User_1]

Hi,
I have thousands of cells in a column and each cell contains long sentences (string). I have to search for a cell that contain two non-consecutive words in a sentence. Note that there may be more sentence with same words either consecutive or non-consecutive.
For example, one cell contain a sentence "You can post a new question by selecting one of the forums below".
If I use the built-in Find (Ctr+F) function and search the words "new" and "forums" then Excel cannot find it because the words are non-consecutive, they are separated by other words.
Is there any way we can find the cells with two words that are in a give sentence but not together? Any macro?

Your help will be appreciated much.
Thanks

 

[Marcelo Branco]

Maybe something like this

=SEARCH(" "&C2&" "&"*"&" "&D2&" "," "&A2&" ")
where C2 houses new and D2 houses forums

M.

 

[Marcelo Branco]

Sorry, the formula above fails if the words are consecutive and separated by one space

Try this new version

=OR(ISNUMBER(SEARCH(" "&$C$2&" "&"*"&" "&$D$2&" "," "&A2&" ")),ISNUMBER(SEARCH(" "&$C$2&" "&$D$2&" "," "&A2&" ")))

M.

 

[Excel_User_1]

Thanks Marcelo,
While this formula works beautifully, I was interested in something like the Find function of Excel that will bring a dialog box to enter the word that need to be searched and once a cell is found with the desired word it will directly take you to that cell.