Blog Archives

Excellent Lookup

VLOOKUP is the traditional method for lookups in Excel, but I never got used to the approximate matches and the need for sorting the lookup data. I have found a better way to setup my lookups, using the INDEX-MATCH combination.

Tagged with: , , , , ,
Posted in Excel