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.
rockerface@lemm.ee 8 months ago
People that use vlookup over index/match are either geniuses or insane. Or both
Sotuanduso@lemm.ee 8 months ago
There’s something other than vlookup?
xpinchx@lemmy.world 8 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.
LetKCater2U@sh.itjust.works 8 months ago
There’s XLOOKUP, which isn’t nearly as volatile as INDEX/MATCH. And also more versatile than vlookup.
SnipingNinja@slrpnk.net 8 months ago
Both. Both is good.
Kill_John_Lennon@lemmy.world 8 months ago
What? Why would you choose to use a combination of 2 formulas when there’s one designed to combine them?