MM0064 - Two Way Lookups In Excel With XLOOKUP
The XLOOKUP formula is a relatively new addition to Excel. Is it worth the hype? Let's find out in this session.
Topics
- | Feedback From Steve On MM62 Project
- | "You Probably CAN Do It In Excel"
- | Two Main Drawbacks Of Excel
- | A Blueprint For An Excel Project
- | XLOOKUP Presentation Start
- | The Concept Of 'Looking Up' Data
- | Main Disadvantage Of VLOOKUP
- | New Formulae Need New Versions Of Excel!
- | Mac vs. PC Balance In 2021
- | VLOOKUP Example
- | MATCH Formula Explanation
- | MATCH / OFFSET Combination Example
- | MATCH Formula Example
- | MATCH / OFFSET vs. VLOOKUP Discussion
- | VLOOKUP With User-determined Column
- | XLOOKUP Example
1 Lesson