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

Iron Contributor



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? 


vstack table list.png


Best regards

- Geir

2 Replies
best response confirmed by Hans Vogelaar (MVP)

@Geir Hogstad 


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.

VSTACK tables.png

Great, it worked perfect. Thank you.