There’s XLOOKUP, which isn’t nearly as volatile as INDEX/MATCH. And also more versatile than vlookup.
Comment on He's got a point
Sotuanduso@lemm.ee 11 months agoThere’s something other than vlookup?
LetKCater2U@sh.itjust.works 11 months ago
xpinchx@lemmy.world 11 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.