VSTACK Function
Stacks arrays on top of each other into one taller array.
Category
Lookup & Reference
Available in
Microsoft 365, Excel 2024
Returns
A spilled array
Overview
VSTACK appends ranges one below another. It's the easiest way to combine lists — for example, the same table from several monthly sheets.
If the arrays have different widths, the narrower ones are padded with #N/A.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array1 | Yes | The first array or range. |
| array2, … | Optional | More arrays to add below. |
Examples
Example 1 — Combining two lists
Stack the East team above the West team.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Ana | Cara | Ana | |
| 2 | Ben | Dev | Ben | |
| 3 | Cara | |||
| 4 | Dev |
Example 2 — Stacking sheets with one header
Combine three monthly sheets, keeping only the first header (the later ranges start at row 2).
A 3D reference works too when sheets sit side by side: =VSTACK(Jan:Mar!A2:C50).
Common mistakes
- #N/A in the result. The arrays have different widths. Use IFNA(…, "") or line the columns up first.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.