VLOOKUP, INDEX, and MATCH Functions in Excel

Giovanni Pace

Description

I'll explain VLOOKUP, INDEX, and MATCH — the three most widely used lookup functions in Excel: let's see how to use them individually and how to combine them to build flexible lookups that VLOOKUP alone can't handle.