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.…
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.…