YoVDO

Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses VLOOKUP Courses HLOOKUP Courses XLOOKUP Courses

Course Description

Overview

Master essential Excel lookup functions in this comprehensive hour-long tutorial. Learn to use VLOOKUP for exact and approximate matches, handle expanding data, and apply HLOOKUP effectively. Explore advanced techniques by combining VLOOKUP with MATCH, and discover the power of INDEX, MATCH, and XLOOKUP as versatile alternatives. Follow along with downloadable Excel files to practice each concept, including exact and approximate matching, expanding data scenarios, and horizontal lookups. Gain practical skills to enhance your data analysis and spreadsheet management capabilities, making this tutorial invaluable for Excel users seeking to improve their lookup function proficiency.

Syllabus

- Vlookup Exact Match
- Vlookup Approximate Match
- Vlookup with Expanding Data
- Using Hlookup
- Combining Vlookup and Match
- Using Index, Match and Xlookup


Taught by

Simon Sez IT

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera