NeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 7 months agoFor all the corporate Excel jockeys out therelemmy.worldexternal-linkmessage-square15fedilinkarrow-up1133arrow-down12
arrow-up1131arrow-down1external-linkFor all the corporate Excel jockeys out therelemmy.worldNeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 7 months agomessage-square15fedilink
minus-squareCuriousRefugee@lemmy.mllinkfedilinkarrow-up12·7 months agoI’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.
minus-squareflorge@feddit.uklinkfedilinkarrow-up6·7 months agoFILTER is another of the more recent excel functions that is also really awesome
minus-squareShadowAndFlamelinkfedilinkEnglisharrow-up5·7 months agoI use FILTER and XLOOKUP on the daily
minus-squareLordPassionFruit@lemm.eelinkfedilinkarrow-up2·7 months agoI 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)
minus-squareShadowAndFlamelinkfedilinkEnglisharrow-up2·7 months agoSad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
minus-squareMilk_Sheikh@lemm.eelinkfedilinkarrow-up5·edit-27 months agoINDEX(MATCH) It’s clunky but the best without bricking older Excel users
minus-squareDeadeyegai@lemmy.worldlinkfedilinkEnglisharrow-up3·7 months agoFuck yeah it is. Even better than the tried and tested INDEX MATCH combo
XLOOKUP is where it’s at.
I’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.
FILTER is another of the more recent excel functions that is also really awesome
I use FILTER and XLOOKUP on the daily
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)
Sad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
INDEX(MATCH)
It’s clunky but the best without bricking older Excel users
Fuck yeah it is. Even better than the tried and tested INDEX MATCH combo