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)
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)