WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
Wise Owl Training
See 479 reviews for our classroom and online training
If you found this blog useful and youâ€™d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

Introducting the new XLOOKUP and XMATCH functions
Part one of a three-part series of blogs

Microsoft have finally recognised the limitations of the VLOOKUP function, and are rolling out the XLOOKUP function to supersede it, as well as the useful (if less significant) XMATCH function.

1. Two new functions in Excel (XLOOKUP and XMATCH) (this blog)
2. The XLOOKUP function
3. The XMATCH Function

Posted by Andy Brown on 13 September 2019

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

# Two new functions in Excel (XLOOKUP and XMATCH)

Coming soon to a desktop near you - a successor to the much-loved VLOOKUP function!  Here's when Microsoft say it will become available:

If you're an Office Insider, you'll already know about this (I'm not, so many thanks to Dave Blake for bringing my attention to this).

There's also a simpler version of the MATCH function coming, which simplifies things by getting rid of one of the arguments.  But did Microsoft do due diligence before naming the function XMATCH?  Here's what the eponymous website offers:

I'm definitely NOT linking to this!

This blog considers both functions, starting with the XLOOKUP function (by far the more useful and important).

1. Two new functions in Excel (XLOOKUP and XMATCH) (this blog)
2. The XLOOKUP function
3. The XMATCH Function