Pulling Data using Excel VLOOKUPs and More
- Live virtual or in person
- 4 hours
- Instructor-led
Live virtual or in person · 4 hours · Instructor-led
Master Excel's lookup and reference functions including VLOOKUP, HLOOKUP, INDEX/MATCH, and XLOOKUP.
Upcoming sessions
Pick a date and register
Course outline
Topics covered
- How does a lookup function work
- Create a VLOOKUP to return a single item of data
- Create a row of VLOOKUP’s
- Create a drop-down list to facilitate your VLOOKUP search criteria selection
- Create VLOOKUP’s that return a column of data
- Create a VLOOKUP that finds the closest match
- Create VLOOKUP that returns multiple columns
- Create VLOOKUP’s nesting the Match function to return multiple out of order columns
- Use XLOOKUP to return multiple columns of data
- Use XLOOKUP with multiple criteria
- Use Index and Match as a substitute for VLOOKUP
- Use Index and Match to find data left of your lookup column
- Use XLOOKUP to find data left of your lookup column
- VLOOKUP Tips
About this course
What this course covers
Excel LOOKUPs are powerful and versatile functions that can save time and effort when working with large datasets, and they are some of Excel's most valuable and least understood functions. They are used to search for specific values within a data range and return related information from another location. In this session, we will explore ways to return data using advanced techniques like VLOOKUP, XLOOKUP, NAMED RANGES, MATCH, and INDEX functions, and more.
Before you attend. Program Level: Advanced.
Your facilitators
Who teaches this course
Ken Worthy
Facilitator
Monica Lewis
Learning On Demand Consultant
Monica B. Lewis has been a contract trainer at Catapult for over a year. As a Microsoft Certified Trainer, she has delivered training in 34 countries and 45 U.S. states, reaching professionals and trainers across many industries. Her Catapult courses include Computer Basics, Outlook, PowerPoint, Word, Excel (including PivotTables and dashboards), and Teams.
See the full team of Catapult HR Advisors.
Good to know
Course questions
It is delivered live online and in person at the Charlotte Learning Center. Each session runs 4 hours.
A single seat is $439 for non-members and $319 for members. It is also included with a Class Pass.
Next: Nov 10 · 3 upcoming dates. Pick a date from the list above to register.
Yes. Private delivery is available for your organization, scheduled around your calendar, live online or on site.
Learners also liked
Courses learners usually take next
MS Word Level 2
Next: Dec 3 · 2 upcoming datesView dates & register →Number Crunching with Excel Pivot Tables
Next: Dec 10 · 3 upcoming datesView dates & register →Computer Basics: Windows and more
Next: Apr 28 · 1 upcoming dateView dates & register →Cyber-Security Essentials
Next: Dec 9 · 3 upcoming datesView dates & register →Related training
More Technology & Digital Skills training
MS OneNote
See upcoming dates
View dates & register →MS Outlook Level 1
Nov 12 · 2 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Vermont · Colorado · Iowa · Montana · Pennsylvania
MS Outlook Level 2
Dec 16 · 2 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
All Courses & Dates
Browse the full catalog of 101 live, instructor-led courses.
Browse the catalog →Technology & Digital Skills
All technology & digital skills courses with upcoming dates.
Explore →All HR Training
Every Catapult training topic and format.
Browse →Private Group Training
Bring this course to your team on your schedule.
Learn more →Register for Pulling Data using Excel VLOOKUPs and More today
Live online, open to your whole team. Or bring it in-house with private delivery.