Forum Discussion
Are references captured by LAMBDA converted to arrays?
Given the following formula, I expected both types to be the same, but I get "1 vs 64", what's going on here? =LET(array, A1:A5,
TYPE(INDEX(array,1,0))
&
" vs "
&
LAMBDA(TYPE...
That does make the types the same but doesn't select the first row like I need.
I've now found that using CHOOSEROWS instead of INDEX always returns an array whether the input is a reference or not.
I've now found that using CHOOSEROWS instead of INDEX always returns an array whether the input is a reference or not.
CHOOSEROWS seems to calculate a bit faster than INDEX, too.