Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Steel Contributor
Jul 15, 2023
Solved

Build a dynamic list with VSTACK based on the table list.

Hi,

 

I might be pushing it now. But it is maybe a solution for this.

 

The goal is to make VSTACK dynamic, build a table based on the table names in the workbook.

 

The green table is a named list of the tables in the workbook. (Made with power query).

 

Using indirect and any other function is it possible to build one formula using VSTACK? Make the "non dymanic function" dynamic? 

 

 

Best regards

- Geir

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jul 15, 2023

    Hogstad_Raadgivning 

    =REDUCE({"Name","City","Rng"},SEQUENCE(ROWS(Tabelle5[Table])),LAMBDA(x,y,VSTACK(x,INDIRECT(INDEX(Tabelle5[Table],y,1)))))

    You can try this LAMBDA function. The names of the three tables on the left in the example are Tabelle2, Tabelle3 and Tabelle4. The name of the small blue table which references the table names is Tabelle5.

2 Replies

Sort By
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jul 15, 2023

    Hogstad_Raadgivning 

    =REDUCE({"Name","City","Rng"},SEQUENCE(ROWS(Tabelle5[Table])),LAMBDA(x,y,VSTACK(x,INDIRECT(INDEX(Tabelle5[Table],y,1)))))

    You can try this LAMBDA function. The names of the three tables on the left in the example are Tabelle2, Tabelle3 and Tabelle4. The name of the small blue table which references the table names is Tabelle5.

Resources