Loading...
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
How to use Excel Vlookup, Hlookup, Xlookup, Match, Index. and Xmatch to look up dataschedule1h
4.5(186)
Tom Fragale
•
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
59 Courses
• 5385 Reviews
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word...
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 hour 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