Introduction
  • Welcome to Lookup Functions
Excel Functions
  • What is a function?
  • How to enter functions
VLOOKUP
  • Introduction to VLOOKUP
  • Finding exact matches
  • Finding approximate matches
  • EXAMPLE: Rewards program
  • Replacing nested conditionals
HLOOKUP
  • Introduction to HLOOKUP
  • EXAMPLE: Product comparison report
LOOKUP
  • Introduction to LOOKUP
  • Looking to the left
  • Disjointed data
  • EXAMPLE: Relational data
Data Validation
  • Drop down lists
  • Scalable lists with tables
Conclusion
  • Stay in touch with me