Excel Index Match Made Simple – Lookup like a Pro

Microsoft Excel Tips and Tricks

In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range. Next, we look at how to use the match function.

Credit Kevin Stratvert