You can use
Range.Find Method [
^] which is used to finds specific information in a range and returns a Range object that represents the first cell where that information is found.
currentFind = this.Fruits.Find("YourSearchString", missing,
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart,
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false,
missing, missing);
Reference Link :-
Search for Text in Worksheet Ranges[
^]