VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here!

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 INDEX/MATCH. Here are some of the queries they had about Index/Match formulas: Is it a lookup and reference formula? (Yes! Maybe the best of …