• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iPhone
  • Mac
  • Web Services

How to Use INDEX MATCH Function in Excel

By: Sam Patwegar | Updated: October 26, 2026

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.

Illustration of Excel INDEX MATCH Function

Advertisement

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.

Computer Sales Data

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

Syntax of INDEX Function in Excel

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

Select Array For INDEX Function in Excel

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.

Start MATCH Function in Excel

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.

Enter MATCH Function Lookup Value

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

Enter MATCH Function Lookup Array

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

Select Match Type in Excel MATCH Function

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

Complete INDEX MATCH Function in Excel

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.

Result of INDEX MATCH Function in Excel

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.

Sam Patwegar

10+ years experience in writing fluff-free troubleshooting guides with just the right and required amount of related information. Equally capable of In-depth technical writing.

Explor More!
  • How to Delete Blank Pages in Microsoft Word Document
  • How to Replace Blank Cells with Zeros in Pivot Table
  • How to Use VLOOKUP Function in Excel

Primary Sidebar

Advertisement



Recent Posts

  • Fix: Start Menu Not Working in Windows 11/10
  • How to Set Sleep Timer in YouTube on iPhone
  • How to Change Text Size On iPhone
  • How to Download All Photos From iCloud to Mac
  • Fix: Duplicate Photos Not Showing on iPhone
Advertisement



© 2026 Techbout.com · All Rights Reserved
About | Privacy Policy | Terms | Contact
Twitter(X) | Facebook