NeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 8 months agoFor all the corporate Excel jockeys out therelemmy.worldimagemessage-square12fedilinkarrow-up1123arrow-down12
arrow-up1121arrow-down1imageFor all the corporate Excel jockeys out therelemmy.worldNeptuneOrbit@lemmy.world to Vanity license plates@lemmy.world · 8 months agomessage-square12fedilink
minus-squareCuriousRefugeelinkfedilinkarrow-up10·8 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-up5·8 months agoFILTER is another of the more recent excel functions that is also really awesome
minus-squareShadowAndFlame@mander.xyzlinkfedilinkEnglisharrow-up5·8 months agoI use FILTER and XLOOKUP on the daily
minus-squareLordPassionFruit@lemm.eelinkfedilinkarrow-up2·8 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-squareShadowAndFlame@mander.xyzlinkfedilinkEnglisharrow-up2·8 months agoSad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing
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