How to use Index Match function in Excel

Just like VLookup function, Match and Index function also used for lookup purpose in Microsoft Excel. Index Match function in Excel works right to left, while VLookup works left to right. In this guide we have to discuss how to use Index Match function in Excel.

Index Match function in Excel allows you to search the specific value from right to left and also reduce the load time. For eg. If you have an worksheet in which you want to search the number of billing parties town wise and month wise. In that situation you have to use Index Match function in Excel to get the exact result.

How to use Index Match function in Excel

Excel is an important utility electronic spreadsheet software. There are lot of variety of function which is used to solve complex calculations. VLookup is one of the most important functions which are found in “Lookup and Reference” category of Microsoft Excel. It is used to searches for a value in the extreme left column of the table_array and provides the value in the same row which is based on the index number.

Step how to use Index Match function in Excel

If you want to use use both Index Match function in Excel to search the value, then you have to take given steps.

Step 1: Create the given worksheet in Excel.

Step 2: Prepare the drop down town name list in cell C11 with the help of Data validation command in Excel. You can also create the month name list in cell C12 with the help of Data validation in Excel.

Step 3: Use the given match function to find the relative position of town name in Cell D11 =MATCH(C11,B3:B8,0). You can find out the relative position of month name with the help of given function in cell D12 =MATCH(C12,C2:H2,0).

Step 4: To find out number of billing parties which match the specific town and month relative position, you have to use Index Match function in Excel. Type the following function in the cell D13 =INDEX(C3:H8,MATCH(C11,B3:B8,0),MATCH(C12,C2:H2,0)).

I hope this guide is useful for all those guys who want to use Index Match function in Excel in single cell. If you have any suggestion or query regarding this guide then please write us in the comment box. Thanks to all.