• 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.