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.

Created by: Chase Raz, M.B.A.
A.B. Gamma

What Will I Learn?

• 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

Requirements

• Basic computer usage skills involving the mouse and keyboard
• Access to Microsoft Excel version 2013 or newer
• Minimal proficiency with Excel including absolute and relative references, as well as the use of functions

Target audience

• Excel knowledge workers looking to advance their skillset
• Data analysis and reporting professionals who work with Excel
• Excel spreadsheet creators, maintainers, or users.