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

YouTube

Excel VLOOKUP Function - All You Need to Know

ExcelIsFun via YouTube

Start learning Write review
DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Babbel Ad

You’re only 3 weeks away from a new language

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course teaches Excel VLOOKUP from basic lookups through advanced techniques, including error handling, named ranges, multi-criteria and partial-text searches, two-way lookups, and dynamic tables. It also briefly introduces HLOOKUP and related MATCH, ROWS, COLUMNS, CHOOSE, and TRIM functions.

Syllabus

2. Why so common? Because everyone needs to look stuff up min
3. VLOOKUP Delivers a value to a cell: Extract Match min
4. VLOOKUP #N/A and IFERROR or IF min
5. VLOOKUP and Data Validation min
6. VLOOKUP with Named Range min
7. VLOOKUP as Formula Element min
8. HLOOKUP = H = Horizontal min
9. VLOOKUP Delivers a value to a cell: Approximate Match min
10. VLOOKUP with table on different sheet min
11. VLOOKUP with table in different workbook min
12. Show Full Record: Numbers above column header min
13. Show Full Record horizontally: COLUMNS Function min
14. Show Full Record vertically: ROWS Function min
15. Show Full Record: MATCH Functions min
16. Two Lookup Values: Add join column as first column in table min
17. Two Lookup Values: Join columns in formula and use CHOOSE function min
18. Partial Text Lookup: LEFT and SEARCH Functions min
19. Partial Text Lookup: MID Function min
20. Partial Text Lookup: RIGHT Function min
21. TRIM and VLOOKUP: Space in lookup value min
22. TRIM and VLOOKUP: Space in 1st column of table min
23. VLOOKUP with 3 lookup tables: CHOOSE Function min
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH min
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula min
26. VLOOKUP and Table feature for Dynamic ranges min

Taught by

ExcelIsFun

Reviews

Start your review of Excel VLOOKUP Function - All You Need to Know

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.