Ignore part of word in search

[Moonbeam111]

I have a macro in sheet2 that looks for a range in "S1:W30" and if its doesnt find any of those word in cell c3 of sheet2 then it alerts me. C3 of sheet2 always equals cell I21 of sheet 1. However, I have a word infront of I21 that I would like for it ignore, lets call that word "Boat". The cell in sheet I21 of sheet 1 always consists of two words and the first word is always boat. How can I have the word in Cell C3 of sheet2 be searched for but exclude the specific word "boat"? And also not put the word boat there when making them equal (see last line of code).

Here is what I have but I dont know how to ignore the first word of the two different words in sheet 1 C21.

Dim f As Range
    Set f = Sheets("Sheet2").Range("S1:W30").Find(Range("I21"), , xlValues, xlWhole, , , False)
    If Not f Is Nothing Then
    Else: Msgbox "New Data Found!"
    Sheets("Sheet2).Range("C3") = Sheets("Sheet1").Range("I21")
    End If

 

[Micron]

maybe

    Set f = Sheets("Sheet2").Range("S1:W30").Find(Range("I21"), , xlValues, xlWhole, , , False)
    If Not f Is Nothing Then
        Msgbox "New Data Found!"
        f = Mid(f,6)
        Sheets("Sheet2).Range("C3") = f
   End If

Unless I'm mistaken you don't need the Else. That assumes there is one space after Boat. If not, adjust 6 to whatever you need.