find formula in excel

Question

is it possible to search for a certain text using =find(...... within a specific column like: C1:C2577

Answer 1

=IF(COUNTIF(C1:C2577,"CertainText")>0, "Present","Absent")

This will tell you if "CertainText" is present or absent in a column

Answer 2

Some VBA code to search for text;

Sub SearchRange()
    Range("C1:C2577").Select
    Selection.Find(What:="SOMETHING").Activate
End Sub