Главная
Study mode:
on
1
) Introduction
2
) VLOOKUP is everywhere
3
) The different between Exact Match & Approximate Match Lookup
4
) VLOOKUP to Lookup Product Price (Exact Match Lookup)
5
) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup)
6
) Data Validation List & VLOOKUP
7
) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References.
8
) Dynamic Lookup Table: Excel Table feature
9
) Dynamic Data Source: Use Power Query to import Lookup Table
10
) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup)
11
) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information)
12
) Fuzzy Lookup = Incomplete Lookup Value
13
) VLOOKUP & IFNA Functions to Avoid Errors
14
) Partial Text Lookup & Converting Text Number to Number
15
) Avoid Zeros from VLOOKUP to Empty Cells
16
) Multiple Table Lookup with VLOOKUP and INDIRECT Functions
17
) Two Lookup Values
18
)Summary
Description:
Dive into a comprehensive video tutorial on the VLOOKUP function in Microsoft Excel, presented by Excel MVP and Highline College Professor Mike Girvin. Explore 15 diverse examples ranging from basic to advanced applications, including exact and approximate match lookups, data validation, dynamic tables, Power Query integration, and complex scenarios involving multiple functions. Learn to master VLOOKUP for product pricing, commission rates, employee information, fuzzy lookups, error handling, and more. Download accompanying Excel files to practice alongside the instructor and gain hands-on experience with each concept covered in this in-depth, 69-minute guide to becoming a VLOOKUP expert.

Mysteries of VLOOKUP Function Revealed - Amazing Examples

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Computer Science #Information Technology #Data Management #Data Validation #Business Intelligence #Power Query #Data Science #Data Analysis #Spreadsheets #VLOOKUP Function #MATCH function
0:00 / 0:00
1 of 18

) Introduction