VLOOKUP vs INDEX MATCH in 2022 — It’s not that bad!

  1. INDEX MATCH: replacing the VLOOKUP function with a standalone INDEX MATCH, so repeated matching for all 10 columns (no caching)
  2. Optimized INDEX MATCH: returning the matched row number (index) once and then using 10 INDEX functions to look up each row value (caching)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Thomas Konings

Thomas Konings

MSc in Management (MiM) student at London School of Economics, MSc Finance from RSM, seeking to connect Finance & Management for better decision-making.