In this article, we will learn to use Index Match formula at the place of Vlookup and Match formula in Microsoft Excel.
How the “INDEX” formula calculates and returns results?
Index function returns a value from the intersection between the row number and the column number in an Array. There are 2 syntaxes for the “INDEX” function.
What are the advantages of using the “INDEX” formula instead of “VLOOKUP” formula?
Let’s take an example to understand:
We have employee’s data in which we have few details: Employee code, Date of joining, Employee name, Designation.
In the 2nd data we want to pick joining date from the first data.
How to pick the value by using Vlookup along with Match function?
Follow below given steps and formula:
Formula Explanation:
How to pick the value by using Index and Match function?
Follow below given steps and formula:
Formula Explanation:-
The main difference between the two formulas is that while using Index there is no need to organize the data table into a special format – you simply find the intersection between a row and a column. While using Vlookup, you always need to move the lookup column to the left side of the data table.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
I need A help .How to make VAT Tax in Excel
https://www.exceltip.com/other-qa-formulas/how-to-calculate-vat-tax-and-net-sale-price-in-microsoft-excel.html