this post was submitted on 13 Apr 2025
31 points (100.0% liked)

Programmer Humor

27141 readers
3421 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

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] xpinchx@lemmy.world 1 points 6 months ago (1 children)

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 ๐Ÿ˜ซ

[โ€“] feannag@sh.itjust.works 1 points 6 months ago* (last edited 6 months ago)

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.