Hands up if you love VLOOKUP or the MATCH functions! I love connecting with fellow Excel enthusiasts but what I've come to realize is that sometimes Excel can outgrow you, especially when running a business takes precedence. Excel is always improving and adding to its functionality which is exciting because it never gets boring and continues to challenge us. But not everyone loves that kind of challenge and that's what I'm here for!
So, you might be familiar with VLOOKUP and MATCH, but have you explored how cool XLOOKUP, XMATCH, FILTER, SORT or UNIQUE are? These newer additions are some of my favourite go-tos but they have only been around a few years, so some people are unfamiliar with them. If you are a fellow enthusiast be sure to add these to your arsenal. If you don’t have the time or desire, you know where to find me! 😉
I absolutely love learning and exploring the ever-expanding functionalities that Excel has to offer and it truly is a continuous learning curve. Let’s be real – no one truly knows it "all". But I do believe there isn't much Excel can't do - well except cook me dinner and clean my house. 😄
And in case you want to know how XLOOKUP works, I have a 'lil graphic to help with that below!