Verifying if text from one cell contained is contained in text in another cell

[TrapHouse]

Is there a way to verify whether or not the text in a cell in a column with first names is contained in text with a column with full names?

eg. verifying whether or not "WILLIAM" in an arbitrary cell, a2, is contained in "William Smith" in f2 and so forth

 

[JLGWhiz]

Is there a way to verify whether or not the text in a cell in a column with first names is contained in text with a column with full names?

eg. verifying whether or not "WILLIAM" in an arbitrary cell, a2, is contained in "William Smith" in f2 and so forth

This snippet would use the value in A2 to look at F2 and see it that same string appeared anywhere in that cell.

Code:
Sub isBill()
Dim sh As Worksheet, myVal
Set sh = Sheets(1)
myVal = sh.Range("A2")
If InStr(sh.Range("F2").Value, myVal) > 0 Then
MsgBox "String Found"
Else
MsgBox "String Not Found"
End If
End Sub
Code:

 

[HalfAce]

Hi,
This can be made to return the name found, or anything you want, but without more to go on, (and for a formula approach) here's something you can try:

=IF(COUNTIF(F2,"*"&A2&"*")>0,"Found","Not-Found")

It's only one way to skin this particular cat.

Hope it helps.