DEV4 Blog

  • Home
  • /
  • Blog
  • /
  • Microsoft Excel: Index and Match

INDEX and MATCH are two functions on Excel which can be used together for a similar purpose as VLOOKUP, however they allow you to search anywhere in the data set. Together, these functions allow you to find the location of the cell you are looking for within the dataset, and use this information to find the value of the cell.

Read the below article for instructions on how to get started with INDEX MATCH:

Microsoft Support Index and Match

Published on 08 Apr 2021 by Joanna Hepburn

Add new comment...