Looking Up Data $-$ INDEX$()$ & MATCH$()$

How do the INDEX$()$ and MATCH$()$ functions work together to fetch data?

The MATCH$()$ function uses the INDEX$()$ function to ascertain the relative position of data in the lookup array

The MATCH$()$ function, when placed inside the INDEX$()$ function, gives the relative position of data within the lookup array

MATCH$()$ identifies equivalent values in the lookup and source tables, while INDEX$()$ provides the position of those values

Scroll down for more

INDEX$()$ identifies the relative position in the source array and produces values for MATCH$()$ to reference

Previous