Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is difference between vlookup and index match function in Excel?

user-image
Question added by Tauseef Valki , Accountant - Team Leader , pharmalink
Date Posted: 2014/07/23
Muhammad Jahanzaib Khan
by Muhammad Jahanzaib Khan , Accountant , Mairaj Uddin Traders

Vlookup work on both type data

static data

dynamic data

you can use with with so many function

index+match not work like Vlookup

if you use Vlookup with data table it's better than index+match

 

Malik Amin Muhammad Khan
by Malik Amin Muhammad Khan , Director Finance and Money Market Dealer , Pakistan Currency Exchange Pvt Lt; Franchise Dollar Shop

Vlookup requires a static column reference while Index requires a dyanmic column reference. With Vlookup, we insert a static specifc number we want to a value returned from. With index function, we manually choose the column to pull off the value. 

More Questions Like This