@ExcelHumor The "if not found" constraint is quiet nice, I must say.
@ExcelHumor The other way around. Xlookup is for peasants
@ExcelHumor What’s xlookup? Don’t you mean index, match?
@ExcelHumor index-match feels more elitist, somehow
@ExcelHumor The index match can be used a split function if you reference 2 or more columns or rows. 🥲 elitism at its finest.
@ExcelHumor People when I use hlookup for anything.
@ExcelHumor works in any direction. "If not found" results. multiple Search modes. Return array can be dynamic. Multiple lookup_arrays instead of a single lookup array.
@ExcelHumor I have yet to master it. Im using it. But I’m not using it
