Question

differentiate between the working of index and match functions in ms excel

Answer 1

Answer:

INDEX returns the value of a cell in a table based on the column and row number. MATCH returns the position of a cell in a row or column. Combining these two functions we can look up a value both horizontally and vertically.

Explanation:

hope it's helpful for you