Forum Discussion

Copper Contributor

Feb 18, 2025

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Feb 18, 2025

As variant

=LET(
    v, VSTACK(
       FILTER(A3:E6, (D3:D6<=C9)*(E3:E6>=C9), FALSE ),
       FILTER(H3:L6, (K3:K6<=C9)*(L3:L6>=C9), FALSE ) ),
    IFERROR( CHOOSECOLS( FILTER(v, CHOOSECOLS(v,1) ), 1,2,4), "no data" )
 )

Matt_Paz

Copper Contributor

Feb 18, 2025

Thank you

If I was to have a different column order in one of the source tables, can choosing columns be independent to each array?
If so can the formula be adapted?