You're viewing a single thread.
All comments
15
comments
XLOOKUP is where it's at.
24 0 ReplyI've been a loyal adherent of the great INDEX(MATCH) for years, but I will have to look at this XLOOKUP deity to see if I should convert.
12 0 ReplyFILTER is another of the more recent excel functions that is also really awesome
6 0 ReplyI use FILTER and XLOOKUP on the daily
5 0 Reply
I know that XLOOKUP is probably better, but I just like my lil INDEX(MATCH) for some reason. You couldn't pay me to convert (you probably could)
2 0 ReplySad, that's what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
2 0 Reply
INDEX(MATCH)
It’s clunky but the best without bricking older Excel users
5 0 ReplyFuck yeah it is. Even better than the tried and tested INDEX MATCH combo
3 0 Reply
15
comments
Scroll to top