Exams $|$ Fundamentals of Data Analysis in Excel

Exit Exam

$12$ out of $15$

Review Later

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

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

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

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

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

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

Previous

Next