Index and Match Function

//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. 2 in the list of SalesPerson –  INDEX(A3:A12,2)

Combination of Index-Match function
Get the NetSales for Satish ?
Use the combination of Index and Match Function.

INDEX(C3:C12,MATCH(A5,A3:A12))
Using Index-Match combination to retrieve a corresponding value has many advantages over Vlookup :

  • Need not select the entire lookup table, just have to select the two columns which are relevant
  • There will be no problem if lookup table goes for any new column inserts

Turtortek is founded by IT professionals with more then 20 years experience and having done management certification from IIM Kolkata. We are focused on delivering project based quality IT trainings in Cloud Computing, Big Data & Hadoop, Analytics, Testing, Web Technologies and Android where the emphasis is mainly on real-time project based learning. We provide instructor led class-room, online training and self-learning video tutorials.

No comments yet.

Leave a comment

Your email address will not be published.