Adv. Excel

/Adv. Excel

Index and Match Function

INDEX-MATCH-vs-VLOOKUP-06

Index and Match Function :

Match –
Searches for the lookup value in the array and returns the index no (position no)
Index –
Opposite of Match, gets us the actual value in the array when the index no. of the array is passed.

1

Match
Gets the index no. of Ramesh from the list of SalesPerson –  MATCH(A4,A3:A12)
Index
Gets the name of the sales person at the position no.