Any Excel user that wants to learn how to use the LOOKUP functions
Learning Objectives
After attending this presentation you will be able to ...
- Identify which lookup function works for your needs
- Distinguish the difference between the many lookup functions
- Recall how to effectively utilize Excel's lookup functions
Major Topics
The major topics that will be covered in this class include:
- A review of the various lookup functions, beyond VLOOKUP
- Learn which lookup works best for your situation
- How to apply the many lookup functions
- Discover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively
- An in-depth review of the following functions:
- VLOOKUP / HLOOKUP
- XLOOKUP
- MATCH / INDEX
- XMATCH
- INDIRECT
- FILTER
- SORT / SORTBY
- UNIQUE
- An overview of some newer functions