Excel is deceptively powerful. Just when I think I’ve mastered it, it pulls another trick out of nowhere. This latest feature has me wondering how much time I’ve wasted not using it sooner. I was at a ...

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works ...