The INDEX-MATCH function in Microsoft Excel is a combination of two functions (Index & Match), in which the MATCH part defines the position of a value in a range and INDEX part retrieves the requested value from that particular position. This results in only the necessary columns in a spreadsheet being evaluated, unlike the VLOOKUP function; which follows a rigid routine of scanning all the columns from left-to-right; regardless of where the lookup value is located.
As you can see in the image below, the INDEX Function defines the location of the Price column (E1:E10) and the Match Function brings up the value of the requested Item in Cell A13 (Chromebook) by going to Column E, where the prices are located.

While the VLOOKUP function is easy to use and popular with Excel users, Index-Match function is much faster and performs better than VLOOKUP; especially when exact-matches are required in a very large dataset.
How to Use INDEX MATCH Function in Excel
To illustrate the use of INDEX and MATCH Functions in combination, let us try to find the Price of MacBook from a Sales Data listing different types of computers sold along with their selling prices.
1. Type the Name of the item (MacBook) for which price is required in Cell A13.

2. Next, place the curser in Cell B13 and start typing =INDEX – This will bring up the Syntax of Index Function.

3. Select E1:E10 as the INDEX Array – This is where the Price of items is located.

4. Now, instead of pointing to Row Number, type =Match – As we are going to use the Match Function to point to the location of Item Name (Chromebook) in our Data.

Note: Manually pointing to the Location of Item Name (Row, Col) is not easy in large data. Hence, the MATCH Function is being used to point to the exact location of the Item Name.
5. Select, Cell A13 as the lookup_value – This is the item for which Price is required.

6. Select A1:A10 as the lookup_array – This is the range where item Names are located.

7. The next step is to state the Match Type – Select 0 – Exact Match.

8. Finally, close the Brackets and hit the Enter Key on the Keyboard of your computer.

Once you press the Enter Key, the INDEX MATCH Function will perform a Matrix search (Horizontally & Vertically) to bring the Price of Chromebook in Cell B13.

As you can see from above image, INDEX MATCH Function has scanned 2 data columns to find the Price of Chromebook, while the VLOOKUP Function would have scanned 5 data columns to accomplish the same task.