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.
You mean like this:
=LET(Found,INDEX(t_priser,,XMATCH(J11,t_priser[#Headers])),XLOOKUP(SMALL(Found,1),Found,Found))
=LET(Found,INDEX(t_priser,,XMATCH(J11,t_priser[#Headers])),XLOOKUP(SMALL(Found,1),Found,Found))
Surer did. Thank you, it worked perfect.
I was a bit to fast with "best reponse" here. Sorry.
Thank you.
Best regards
- Geir
I was a bit to fast with "best reponse" here. Sorry.
Thank you.
Best regards
- Geir