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