Review Later

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

Which of the following statements describes how the INDEX$()$ and MATCH$()$ functions are combined to lookup data?

MATCH$()$ is used to match values from the lookup table and the source table, INDEX$()$ returns the index of these values

MATCH$()$ is used within the INDEX$()$ function to return the relative position of the data in the lookup table

INDEX$()$ is used within the MATCH$()$ function to return the relative position of the data in the lookup table

INDEX$()$ calculates the relative position of the data in the source table and returns values for MATCH$()$ to lookup