Using Excel Vlookup, Hlookup, Xlookup, Match, and Index | CPDFormula by learnformula
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
schedule 1h
CA$83
-54%
CA$182
UNLIMITED ACCESS
Get Full Access to Every Course
Get this course, plus our top-rated courses, with an active subscription. Learn More
Annual subscription only CA$83. Cancel anytime.
checkAccess to all courses with active subscription
checkNo additional payments
checkExclusive content updates
About this package
CPA OntarioCPA British ColumbiaCPA AlbertaCPA SaskatchewanCPA ManitobaCPA Quebec Order
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 package 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
Using Excel Vlookup, Hlookup, Xlookup, Match, and Index
How to use Excel Vlookup, Hlookup, Xlookup, Match, Index. and Xmatch to look up data
