Lookup

FormulaRelated Functions
Self-contained VLOOKUP
Two-way lookup with INDEX and MATCH
Two-way lookup with VLOOKUP
VLOOKUP with 2 lookup tables
VLOOKUP with calculated column index
VLOOKUP with numbers and text
VLOOKUP with two or more criteria
VLOOKUP without #N/A error