this post was submitted on 13 Apr 2025
1252 points (99.5% liked)
Programmer Humor
22469 readers
1228 users here now
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
Rules
- Keep content in english
- No advertisements
- Posts must be related to programming or programmer topics
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
There's no way they're using xlookup at year 7. You can pry my index match from my cold dead hands.
Xlookup works fine for like 90% of cases, I save index match mainly for when I need to return multiple lookup values. In which case I load into BI because I always forget how index match works ๐ซ
I should probably learn how BI works, but I'm mostly torturing excel to do things it was never intended to do.
Also I do a lot of lookups and xlookup will slow my sheet down.
Yeah if its something ad hoc I'll paste values but for sheets meant to be maintained I'll do it in PQ through merges or calculated columns. Lookups get the job done but they are expensive ;)
cackles manically in DAX