gigastasio@sh.itjust.works to Ask Lemmy@lemmy.world · 12 天前What's that video game boss you've never been able to beat, or took you the longest to beat?message-squaremessage-square235linkfedilinkarrow-up1143arrow-down13
arrow-up1140arrow-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 · 12 天前message-square235linkfedilink
minus-squarebstix@feddit.dklinkfedilinkarrow-up2·11 天前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.
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