From finding an employee name based on their ID number, to finding a product by its product number, XLOOKUP is a valuable tool that allows you to extract specific information when dealing with large sets of data.
XLOOKUP is in addition to VLOOKUP, the older version of this function, and is a major improvement on its predecessor, providing more flexibility, extra functionality and, most importantly, being easier to use when it comes to finding specific data from a range.
With VLOOKUP, data has to be organised so that the value you look up (e.g. the product number) is to the left of the return value (e.g. the product name) you want to find. With XLOOKUP, it doesn’t matter which side the return column is on.
As well as this, XLOOKUP has the following added improvements:
Whilst this may sound too good to be true, the important thing to remember is that the XLOOKUP function is only available to Microsoft Office 365 users, so you could be missing out on this timesaving and stress-reducing formula if you use the standard Microsoft Office suite.
Hosted by Microsoft and supported by Infuse, Microsoft’s Office 365 suite of products offers a multi-functional cloud service, allowing you to work anywhere, at anytime, on any device. Office 365 can keep you up to date with the latest software and security features, and also comes with built-in disaster recovery.
For more information on how Office 365 can upgrade the way you do business, or finding the Cloud solution that’s perfect for you, please get in touch.
Talk through your IT needs with one of our friendly technicians – no commitment, no cost!
Complete our contact form and one of our experts will be in touch, or call our team on 01332 374444.
Array ( )