you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 4 months ago (1 child)

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.

  • source
  • parent
  • hideshow 1 child comment