Coursera Plus Annual is 40% Off — Ends July 13.

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

LinkedIn Learning

Excel: VLOOKUP and XLOOKUP for Beginners

via LinkedIn Learning

Write review
Simplilearn Ad

Build GenAI Apps from Scratch — UCSB PaCE Certificate Program

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.

Syllabus

Introduction
  • Find data quickly in Excel
  • What can you do with XLOOKUP in Excel?
1. Using Lookup Functions
  • Creating a simple XLOOKUP
  • Creating a simple VLOOKUP
  • Handling errors with the @IFERROR function
  • Use dropdown lists and Excel tables for more error-proofing
Conclusion
  • Expand your Excel function and formula skills

Taught by

Jess Stratton

Reviews

4.7 rating at LinkedIn Learning based on 5955 ratings

Start your review of Excel: VLOOKUP and XLOOKUP for Beginners

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.