Microsoft Excel Tip – Goodbye VLOOKUP, Hello XLOOKUP

microsoft excel training

What is the XLOOKUP Excel function?

Microsoft Excel Tips

XLOOKUP is a more powerful function that will eventually make functions like VLOOKUP, HLOOKUP and LOOKUP redundant. The XLOOKUP performs the same as a VLOOKUP, however, is much more flexible.

Here are the advantages of XLOOKUP over VLOOKUP:

  • No longer do you need to worry about the lookup column being first in your table
  • You save time – as the basic version of XLOOKUP assumes you are looking for exact matches by default
  • You don’t need to see the #NA error anymore as one of the arguments allows you to customise the message for the user if the item isn’t found

XLOOKUP will ONLY be available to Office 365 subscribers

If you would like to learn more, book in for our Excel Advanced half day course or contact us for a customised course.


microsoft training courses excel

Microsoft Excel Training

Our virtual and face-to-face Office and Excel training courses will empower your team to boost productivity.
Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.

computer trainers sydney

CJ Computer Training Sydney

Virtual and Face-to-Face Computer Trainers

As a Learning and Development team, Jan and Celine are passionate about training and want to help you boost your productivity, as well as your confidence. We do this by identifying skill gaps and then develop and deliver training to bridge those gaps. Our aim is to empower learners to improve productivity and embrace the digital tools that are available in the workplace and home.

Meet our Sydney computer trainers »