COURSEUS$127
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
How to use Excel Vlookup, Hlookup, Xlookup, Match, Index. and Xmatch to look up data
schedule 1 hour4.5(183 ratings)
starstar
starstar
starstar
starstar
star_halfstar
-54%
US$58
![Course image](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fimages%2Fcourses%2F3077%2F41f1b383d2c7b11fd8186345a91b30ec.jpeg&w=640&q=75)
auto_storiesINSTRUCTOR(S)
![](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fusers%2F9198%2Fd51f255d2ff0c02ebf47efd645af1335.jpeg&w=96&q=75)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
In Excel, sometimes there is a need to look up information from a table or from a different sheet, or to link the sheets together. This course will show you how to do that with the following functions/formulas:
- Vlookup
- Hlookup
- Xlookup
- Match
- Index
- Xmatch
- Linking sheets with formulas
- Data Consolidation
This course includes:
schedule1 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Nov 12, 2020
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At May 9, 2021
HomepageBecome an InstructorLearnFormula PodcastsLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2025 CPE QAS LearnFormula | Professional Development Course Marketplace