• 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