4.4  313 reviews on Udemy

Excel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions

Learn to use some of the most popular Excel functions for tabular lookups. Learn VLOOKUP, HLOOKUP, and LOOKUP functions.
Course from Udemy
 1398 students enrolled
Replace lengthy nested IF functions in Excel spreadsheets
Return information associated with a lookup value from a table
Identify the location of a lookup value within a table

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

Excel Crash Course:  VLOOKUP, HLOOKUP, and LOOKUP Functions
$ 39.99
per course
Also check at

FAQs About "Excel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions"


Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.