=VSTACK FORMULA RESULTS IN #NAME?

[Emanuel1710]

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]

@Emanuel1710 

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.

[#3]

@Emanuel1710 

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.