Warning: Some posts on this platform may contain adult material intended for mature audiences only. Viewer discretion is advised. By clicking ‘Continue’, you confirm that you are 18 years or older and consent to viewing explicit content.
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.
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.