Lookup & Reference
Excel 365
◉ 6 views
Dynamic Array
=VSTACK()
The arrays to append.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac
=VSTACK(array1,[array2],...)
Hover argument names in the table for details.
Output typeArray
Popularity60 / 100
VolatileNo
Dynamic ArrayYes
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =VSTACK() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Range | Required | The arrays to append. |
▣ Examples
چسباندن عمودی دو محدوده A2:C3 و E2:G3
=VSTACK(A2:C3,E2:G3)
چسباندن عمودی سه آرایه با ابعاد متفاوت
=VSTACK(A2:B4,C2:D3,E2:F2)
چسباندن عمودی با تکسلول F2 در انتها
=VSTACK(A2:B4,C2:E3,F2)
✦ Tips
- VSTACK returns the array formed by appending each of the array arguments in a row-wise fashion. The resulting array will be the following dimensions:
- Rows: the combined count of all the rows from each of the array arguments.
- Columns: The maximum of the column count from each of the array arguments.
⚠ Common Errors
#N/A
If an array has fewer columns than the maximum width of the selected arrays, Excel returns a #N/A error in the additional columns. Use VSTACK inside the IFERROR function to replace #N/A with the value of your choice.
Fix: Make the number of columns equal or use IFNA
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!