BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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).