Forum Discussion
Dealing with VSTACK with empty arrays
Hi all Question - do you know how to still display data when there is an empty array within VSTACK? Currently my formula works but displays CALC when an array is empty. I have two tables, both with...
=LET(stacked,VSTACK(A3:E6,H3:L6),IFERROR(SORT(FILTER(FILTER(stacked,(INDEX(stacked,,4)<=C9)*(INDEX(stacked,,5)>=C9)),{1,1,0,1,0}),3,1,FALSE),"ERROR"))This formula works if there is no match in range H3:L6. You can as well clear all data in range H3:L6 and the formula still returns the intended result. The same applies for range A3:E6.