If you like VLOOKUP, you'll love XLOOKUP.
XLOOKUP has everything that VLOOKUP has, but much more. For example:
- Lookup and Return arrays are separate, meaning you can look up columns to the left
- You can return multiple columns at once
- You can build in an 'if not found' condition
- You have much more matching functionality (and the default is TRUE)
You'll need a good grasp of VLOOKUP to benefit from this mini-course
Course contents
XLOOKUP for VLOOKUP users
Available in
days
days
after you enroll
"Hi, my name is Martin Healey and Excel is my passion. My job is to help you build your own skills, so you can be really confident about putting Excel to work.
My experience includes running my own retail business, working as a vocational trainer, and teaching lots of Excel courses.
My qualifications include an MBA and a diploma in vocational training.
I hope you decide to invest some of your time in learning Excel properly. I promise you won't be disappointed."
Putting Excel to work - enroll in this comprehensive course to really get confident in Excel.
Do you avoid working on your spreadsheets when your colleagues are around?
Are you embarrassed about how long it takes you to build a formula?
Would you claim to have Excel experience on your CV?
It's time to take control and learn how to use Excel's wonderful tools properly.
Hold your own against the Excel 'experts' in the office.
Go home early.