Searching for more than One piece of text

Hi

I'd use an = IF(ISERROR(MATCH("*50*,A:A,False),"Not Found") in one column adjacent to your strings, and =ISERROR(MATCH("*engineering*",A:A,False),"Not Found") in in another.

Copy these down and then filter the columns for values that don't have Not Found.

Not what you asked for but a macro like this could do it:

Option Explicit

Sub FindStr()
Dim cell As Range

For Each cell In Range("B1:B15")

If InStr(cell, "50") > 0 And InStr(cell, "engineering") > 0 Then
    cell.Offset(0, 1).Value = "Match"
End If

Next

End Sub

Or perhaps somebody with more know how than me could write this as an UDF?

By the way the command InStr is case sensetive so a combination of "Engineering" and "50" will not be taken as a match.

Alf

These could work for you. This has the titles in column A starting at A2 use this in column B (or column of your choice) and fill down:

Formula:

=IFERROR(IF(AND(SEARCH("*50*",A2),SEARCH("*engineering*",A2)),"Found"),"")

If you want to be able to enter different terms in say cells D1 and E1 use this in column B (or column of your choice) and fill down:

Formula:

=IFERROR(IF(AND(SEARCH("*"&$D$1&"*",A2),SEARCH("*"&$E$1&"*",A2)),"Found"),"")