During one of my Excel training sessions, I was surprised to find out that the people were aware and quite proficient in using
VLOOKUP, but most of them had no idea about
Here in this blog post, I will try and compare these 2 formulas as objectively as I can in terms of popularity, ease of use, flexibility, and speed.
INDEX/MATCH is powerful combo that has more flexibility and speed formula than the
VLOOKUP formula. If you haven't already adopted
MATCH as the way of life, it is time you do it.
Full article: VLOOKUP vs. INDEX/MATCH – The debate ends here!