• CuriousRefugee@lemmy.ml
      link
      fedilink
      arrow-up
      12
      ·
      8 months ago

      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.

      • florge@feddit.uk
        link
        fedilink
        arrow-up
        6
        ·
        8 months ago

        FILTER is another of the more recent excel functions that is also really awesome

      • LordPassionFruit@lemm.ee
        link
        fedilink
        arrow-up
        2
        ·
        8 months ago

        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)

      • ShadowAndFlame
        link
        fedilink
        English
        arrow-up
        2
        ·
        8 months ago

        Sad, that’s what they taught us in college ~2017 but XLOOKUP is just that but better and less typing