Excel MATCH Function

MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH.

=MATCH(E2,B3:B11,0)
=MATCH("pq*",B3:B11,0)
=MATCH("peach",B3:B9,0)

References
https://exceljet.net/excel-functions/excel-match-function