Udemy
UdemyExcel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions
4.5(427)1k studentsINTERMEDIATEEnglish
Korshub's take
Replace messy formulas with clean lookup logic
VLOOKUP, HLOOKUP, and LOOKUP functions solve the nested-IF trap that plagues corporate Excel. Instructors with over eight years of corporate training experience teach you when to use each function and how to build scalable solutions instead of fragile formula tangles.
Learn to pull data from disjointed tables, autofill across transposed ranges, and create dynamic drop-down validation lists that adapt without breaking. Perfect for professionals stuck in outdated workflows, this focused crash course eliminates the most common source of Excel frustration. Tight, practical, no padding—just the functions that matter and how professionals actually use them.
About this course
VLOOKUP is one of the most requested Excel function tutorials that I've received in over eight years of providing corporate training in Microsoft Excel. All too often, professional Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested IF statements) are certainly towards the top of the list. Learn to solve this, and other problems, by utilizing the VLOOKUP, HLOOKUP, and LOOKUP functions.
Some of the abilities you'll gain by understanding these functions are:
Eliminate nested conditional (IF) statements
Pull data from disjointed or broken tables
Allow for autofill even when a reference table is transposed
Create scalable drop-down validation lists
Price
$39.99
No active coupon right now
View Course →Advertisement
