Introduction
  • Introduction - What are LOOKUP's?
  • Downloadable Files
  • My Latest Course! Free for a Limited Time Only
Creating Your First VLOOKUP
  • Case Study Explained and Demonstration
  • Structure of the VLOOKUP
  • VLOOKUP using Exact Matching
  • VLOOKUP using Approximate Matching
Table to Table Combinations using Absolute Referencing
  • Column to Column Linking
  • Extended Columns and Incomplete Array Data Tables
  • Dealing with Errors using Iferror Function
  • 2 Dimensional Table Linking
Horizontal Look Up Comparison to Vertical Look Up
  • Horizontal Look Up in action
Bonus Lessons: Building your own search engine
  • Demonstration - Student Grade Compiler
  • Creating a Single Search - Typed in and Data Validation Method
  • Search Results: Building the "If" Counter
  • Search Results: VLOOKUP and Data Validation
Congratulations
  • All My Courses
  • Help Me Inspire More People!
  • Congratulations
  • Check us out on Facebook!