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:

New functions timescale

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:

The XMATCH website

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
This blog has 0 threads Add post