What is MATCH Function in Excel?

The Match Function:

The MATCH function is designed for one purpose: find the position of an item in a range. For example, we can use MATCH to get the position of the word “peach” in this list of fruits like this:

=MATCH(“peach”,B3:B9,0)