Forum Discussion
Solved
Let function used with Index.
Hi, I try to figurer out how to use the new LET function, in this example wich has the same INDEX function several times. Is it possible, if yes, aht is the solution? Example file is at...
Afraid that won't work without lambdas since required array of arrays. If only PeterBartholomew1 knows some trick.
JKPieterse, Can I ask what is the point of the second XLOOKUP in that equation is for?
XLOOKUP(SMALL(Found,1),Found,Found)
Doesn't that just find the smallest value then look it up in the same array and return that same value again? I guess I'm asking why SMALL(Found,1) wouldn't work.
XLOOKUP(SMALL(Found,1),Found,Found)
Doesn't that just find the smallest value then look it up in the same array and return that same value again? I guess I'm asking why SMALL(Found,1) wouldn't work.
I honestly don't know, I simply converted the formula to leverage the LET function. I did wonder about that though.