Lookup in Excel: Functions and formula examples

Lookup in Excel: Functions and formula examples

20 April 2017

The tutorial explains the basics of lookup in Excel, shows the strengths and weaknesses of each Excel lookup function and provides a number of examples to help you decide which lookup formula is best to be used in a particular situation.

The lookup functions discussed are:

  • LOOKUP.
  • VLOOKUP.
  • HLOOKUP.
  • VLOOKUP MATCH.
  • HLOOKUP MATCH.
  • OFFSET MATCH.
  • OFFSET MATCH MATCH.
  • INDEX MATCH.
  • INDEX MATCH MATCH.