Forum Discussion
=VSTACK FORMULA RESULTS IN #NAME?
Hello
when trying to combine sheets data into one consolidate sheet i get the below error
#NAME?
below is the formula i tried with above result
=vstack('Mutual Funds Tracker (3)'!B22:F26,'Mutual Funds Tracker (2)'!B22:F23)
Rgds
Emanuel
2 Replies
VSTACK is only available in Excel in Microsoft 365, version 2208 and later.
It is not available in Excel in Office 2021, 2019, 2016 etc.
Do you work with the english version of Excel? In this case you can use VSTACK. I work with german Excel and the translation for german Excel is VSTAPELN. For example in french Excel it should be ASSEMB.V and in spanish Excel APILARV.
