Getting started with VLOOKUP
  • Introduction to VLOOKUP
  • Syntax of VLOOKUP
Writing VLOOKUP Function
  • Writing your first VLOOKUP Function
VLOOKUP Function in a List
  • Writing VLOOKUP with Absolute Reference for Lists
  • Using Range Lookup for VLOOKUP Function
Multi-sheet / Multi-workbook VLOOKUP
  • Writing a multi-sheet VLOOKUP
  • Writing VLOOKUP in a multi-workbook setup.
VLOOKUP with other functions
  • VLOOKUP with MATCH
  • VLOOKUP with IFERROR
Further VLOOKUP
  • VLOOKUP with wildcards
  • VLOOKUP multiple columns
  • VLOOKUP for specific occurrence