INDEX and MATCH: the dynamic duo
Look up information in any direction.
VLOOKUP has one limitation: it only looks to the right. If the information you want is on the left, it can't help. The solution is to use two functions together:
Module: Looking up information. Lesson 23 of 62.