Microsoft Excel: Functions - INDEX and MATCH
INDEX and MATCH when used together are similar to VLOOKUP, in that they find information based on a matching value. They give you more flexibility than VLOOKUP.
MATCH can be used independently of INDEX. If you use VLOOKUP, MATCH can be used to work out your Column Index Number for you.