Mysteries of VLOOKUP Function Revealed - Amazing Examples

This course teaches VLOOKUP in Excel through examples ranging from basic exact and approximate matches to dynamic tables, Power Query imports, two-way and fuzzy lookups, error handling, and multi-table formulas.

Syllabus

) Introduction.
) VLOOKUP is everywhere.
) The different between Exact Match & Approximate Match Lookup.
) VLOOKUP to Lookup Product Price (Exact Match Lookup).
) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup).
) Data Validation List & VLOOKUP.
) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References..
) Dynamic Lookup Table: Excel Table feature.
) Dynamic Data Source: Use Power Query to import Lookup Table.
) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup).
) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information).
) Fuzzy Lookup = Incomplete Lookup Value.
) VLOOKUP & IFNA Functions to Avoid Errors.
) Partial Text Lookup & Converting Text Number to Number.
) Avoid Zeros from VLOOKUP to Empty Cells.
) Multiple Table Lookup with VLOOKUP and INDIRECT Functions.
) Two Lookup Values.
)Summary.