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
Our Promise to You
By the end of this course, you will have learned different ways to look up information in Excel.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about lookup functions in Excel.
Course Curriculum
Section 1 - Looking Information Up In Excel | |||
Exercise Files | 00:00:00 | ||
VLOOKUP Exact Match | 00:00:00 | ||
XLOOKUP Exact Match | 00:00:00 | ||
VLOOKUP And XLOOKUP Range Match | 00:00:00 | ||
HLOOKUP | 00:00:00 | ||
Match, Index, Xmatch | 00:00:00 | ||
Linking Sheets | 00:00:00 | ||
Data Consolidation | 00:00:00 |