• xpinchx@lemmy.world
    link
    fedilink
    arrow-up
    1
    ·
    2 months ago

    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 😫

    • feannag@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      1
      ·
      edit-2
      2 months ago

      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.