cm0002@lemmy.world to Programmer Humor@programming.dev · 27 days agoExcellemmy.mlimagemessage-square41fedilinkarrow-up119arrow-down10cross-posted to: programmerhumor@lemmy.ml
arrow-up119arrow-down1imageExcellemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 27 days agomessage-square41fedilinkcross-posted to: programmerhumor@lemmy.ml
minus-squarefeannag@sh.itjust.workslinkfedilinkEnglisharrow-up1·26 days agoThere’s no way they’re using xlookup at year 7. You can pry my index match from my cold dead hands.
minus-squarexpinchx@lemmy.worldlinkfedilinkarrow-up1·26 days agoXlookup 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 😫
minus-squarefeannag@sh.itjust.workslinkfedilinkEnglisharrow-up1·edit-226 days agoI 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.
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.