Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)

ExcelIsFun via YouTube

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.

Taught by

ExcelIsFun

Reviews

Start your review of Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.