Overview
XLOOKUP replaces VLOOKUP and it allows you to solve previous impossible lookup challenges. XLOOKUP works well with dynamic arrays and offers solutions to challenging Excel problems.
Why you should Attend
Struggling to get your lookups to work?
Are you frustrated with VLOOKUP?
XLOOKUP solves most of VLOOKUP problems. It offers extra solutions that can meet most of your lookup requirements.
Areas Covered in the Session
- Learn the basics of the XLOOKUP function
- Discover how easy it is to handle N/A! errors
- See how to look from the bottom, up
- Use XLOOKUP to return a reference
- See how to use XLOOKUP with dynamic arrays
- Learn how to return multiple columns
- Discover how to do wildcard searches
- See how to select from multiple tables
- Learn how to do two-way look ups
- Discover how to do two-column lookups
- Return multiple rows with the FILTER function
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Instructor
Neale Blackwood