And given how much can be done with this single function, I don’t blame them.įor this reason, a lot of people use VLOOKUP as it is better understood by other Excel users.Īlthough this is not a popularity contest, it plays a huge role in why VLOOKUP gets used so much. The popularity of the functionįor some people, if you know how to use VLOOKUP, you know how to use Excel. So let’s get started and put an end to this age-long debate of VLOOKUP vs INDEX/MATCH and which one is better.Īnd to do this, I will compare these two functions on some parameters (some are quantifiable and some are not). ![]() VLOOKUP Vs INDEX MATCH – An Objective Comparison ![]() The choice is driven by a lot of factors including what the data looks like and how it would be used. I don’t have favorites, to begin with, but I prefer using the INDEX/MATCH combo more than VLOOKUP.
0 Comments
Leave a Reply. |