gigastasio@sh.itjust.works to Ask Lemmy@lemmy.world · 5 days agoWhat's that video game boss you've never been able to beat, or took you the longest to beat?message-squaremessage-square235linkfedilinkarrow-up1145arrow-down12
arrow-up1143arrow-down1message-squareWhat's that video game boss you've never been able to beat, or took you the longest to beat?gigastasio@sh.itjust.works to Ask Lemmy@lemmy.world · 5 days agomessage-square235linkfedilink
minus-squarebstix@feddit.dklinkfedilinkarrow-up2·4 days ago Vlookup Please use xlookup instead. Forget about lookup, vlookup, hlook-up or index(match()). Only use xlookup.
minus-squareMonkRome@lemmy.worldlinkfedilinkEnglisharrow-up1·4 days agoNo place I have ever worked has had a version of excel with xlookup, so I can’t really comment on it. Im not on 365 or a newer desktop version. We are on Office 2019, as I suspect many offices still are.
minus-squarebstix@feddit.dklinkfedilinkarrow-up2·4 days agoOk, xlookup is better because it doesn’t return false positives and it also doesn’t require the data to be sorted. It almost does the same as index(match()), only better, easier and faster.
Please use xlookup instead.
Forget about lookup, vlookup, hlook-up or index(match()).
Only use xlookup.
No place I have ever worked has had a version of excel with xlookup, so I can’t really comment on it. Im not on 365 or a newer desktop version. We are on Office 2019, as I suspect many offices still are.
Ok, xlookup is better because it doesn’t return false positives and it also doesn’t require the data to be sorted.
It almost does the same as index(match()), only better, easier and faster.
Arrayformula() friendly too