What does MATCH return and how does it differ from INDEX?

Question

Microsoft Excel — Medium

What does MATCH return and how does it differ from INDEX?

Accepted Answer

The MATCH function returns the relative position of a value within a specified range, whereas INDEX uses this position to retrieve the actual value. This distinction is crucial. MATCH's output is a numerical position, not the value itself. INDEX relies on MATCH's output to fetch the correct value.