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.
People that use vlookup over index/match are either geniuses or insane. Or both
There’s something other than vlookup?
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.
There’s XLOOKUP, which isn’t nearly as volatile as INDEX/MATCH. And also more versatile than vlookup.
Both. Both is good.
What? Why would you choose to use a combination of 2 formulas when there’s one designed to combine them?