Search Feature

What we need to know is the word(s) your are looking for and
the range where the word(s) might be found.

You would need to use an input cell and VBA code to find the value.
As rwgrietveld suggested, a sample workbook would be helpful. However, here is the basic code and a sample workbook to get you started.

This will search for a value entered into cell D1 and will only look in column-A.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim strFind As String, rFound As Range
    
    If Not Intersect(Target, Range("D1")) Is Nothing Then
        If Target.Value <> vbNullString Then
            strFind = Target.Value
            With Target
                Set rFound = Columns(1).Find(what:=strFind, after:=Cells(1, 1), LookIn:=xlValues, lookat:=xlPart, _
                    searchorder:=xlByRows, searchdirection:=xlNext, MatchCase:=False, searchformat:=False)
                On Error GoTo 0
                If Not rFound Is Nothing Then Application.Goto rFound ', True
            End With
        End If
    End If

End Sub

also...
What do you want as the result?
eg, the sheet/cell address of where the word is found,
or,
a value in an adjacent column to where the word is found,
or...

If you are open to using macros, Tushar's Findall code may be of interest: http://www.tushar-mehta.com/excel/tips/findall.html

hth
Rob