Once you have mastered VLOOKUP in Excel it’s time to move on to INDEX/MATCH. This formula combination is far superior to VLOOKUP.
The limitation of Vlookup is you can search only for the values on the right to your search word or number. also the result of Vlookup is very sensitive if you decided to insert (or delete) a column in your dataset because the column numbers are hardcoded. Index/Match formula combination seems to solve all the above limitations and offers far more flexibility and possibilities.