Tag Archives: XLOOKUP

XLOOKUP Webinar

XLOOKUP is the next-gen lookup function designed to address the limitations of VLOOKUP and related workarounds. It combines the capabilities of numerous functions including VLOOKUP, INDEX, MATCH, HLOOKUP, and IFERROR. Many have asked me to teach this via webinar. So, I created this short webinar that covers the basics 🙂 This on-demand webinar is about […]



XMATCH

When Microsoft released XLOOKUP, they also released XMATCH. XMATCH hasn’t received as much attention as XLOOKUP, so I wanted to talk about it here. In summary, it is similar to the legacy MATCH function we’ve been using for decades, but it receives similar enhancements introduced with XLOOKUP. Let’s get to it. XMATCH Before we get […]



XLOOKUP

Raise your hand if you love VLOOKUP? Me too! We Excel users have grown to love VLOOKUP over the years. But, XLOOKUP offers some advantages. XLOOKUP? That’s not a typo. Depending on your version of Excel and when you are reading this, you may see this function immediately, or it may be a while before […]