cm0002@lemmy.world to Programmer Humor@programming.dev · 2 months agoExcellemmy.mlimagemessage-square41fedilinkarrow-up140arrow-down10cross-posted to: [email protected]
arrow-up140arrow-down1imageExcellemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 2 months agomessage-square41fedilinkcross-posted to: [email protected]
minus-squarexpinchx@lemmy.worldlinkfedilinkarrow-up1·2 months 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-22 months 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.
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.