Forum Discussion
Dynamic Let Function
If you have a long let function with lots of variables, it is annoying to audit. It is also a shame that all the other info in the let function is "trapped" without manually going in to change the i...
I think what you want is to have the "index_num" to be an array like: XMATCH(item_array,item_array)
but the problem is that it is a column of values and the 'item_array' is a column so it will only show the one value.
In the attached I created a version with XMATCH(TOROW(item_array),item_array), and that does produce the array output but because the other values are single values it repeats them for the 'array' so the grid is 'ugly'.
Since you are manually adding the list of variables why not just spit them out using something like:
IFERROR(VSTACK({"a","b","c","d","e","f","item","item_array","index_num"},
HSTACK(a,b,c,d,e,f,item,item_array,index_num)),""))
But then maybe I don't understand your goal.