• xpinchx@lemmy.world
          link
          fedilink
          arrow-up
          8
          ·
          7 months ago

          Good God please use xlookup. We have some old school people that still use vlookup and refuse to convert their ranges to tables, it drives me crazy.

          I still use index/match for multiple lookup returns (or is it sumifs I can’t remember?) But I do a lot of work in BI and it’s much more intuitive for me in DAX/M.