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