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.
If the objective is to examine the use of the LET function, the following demonstrates the way in which a solution may be built using formula-local names
= LET(
Found,XLOOKUP(@Modell,t_priser[#Headers],t_priser),
BestPrice, SMALL(Found,1),
Utileier, IF({1,0}, t_priser[Utlleier], Found),
XLOOKUP(SMALL(Found,1),Found,Utileier)
)The additional trick is to combine the seller and their prices for the vehicle type into a table and then perform the second lookup to select the best offering.
If the entire table were required as a single spilt range, that would need a plunge into LAMBDA to perform the array of array calculations and collect the results for each.
I meant one spill for all results is required