Nov 16 2022 12:05 PM - edited Nov 16 2022 12:05 PM
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(INDEX(array,1,0)))()
)
Are references captured by LAMBDA converted to arrays?
If so, is there a way I can force the first to be converted to an array too?
Nov 16 2022 12:23 PM
Nov 16 2022 12:32 PM
The INDEX is returning a scalar so TYPE returns a 1.
This might work:
=LET(array, A1:A5,TYPE(array)&" vs "&LAMBDA(TYPE(INDEX(array,1,0)))())
Nov 16 2022 12:45 PM
Nov 16 2022 12:57 PM