# Why does VLOOKUP return #SPILL! in Excel 365?

The lookup value is a whole column, so VLOOKUP tries to return a result for every row. Look up one cell and fill down: =VLOOKUP(B2,$E$2:$F$4,2,FALSE).

**Excel:** `=VLOOKUP(B2,$E$2:$F$4,2,FALSE)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| Ticket | Agent | Team |  | Agent | Team |
| T-901 | Kim |  |  | Kim | Billing |
| T-902 | Raj |  |  | Raj | Tech |
| T-903 | Kim |  |  | Lee | Sales |
| T-904 | Lee |  |  |  |  |
| T-905 | Raj |  |  |  |  |
| T-906 | Lee |  |  |  |  |

Formula in C2, filled to C7: `=VLOOKUP(B2,$E$2:$F$4,2,FALSE)`

Result: Billing; Tech; Billing; Sales; Tech; Sales

## How it works

In Excel 365, `=VLOOKUP(B:B,…)` asks for a result for every row of column B: about a million of them. That can't spill into the sheet, so Excel shows #SPILL!. Looking up one cell, `B2`, returns one result, and filling down gives each ticket its team.

## Other ways

- `=XLOOKUP(B2,$E$2:$E$4,$F$2:$F$4)`: The XLOOKUP version, also one result per row.

## Common mistakes

- `=VLOOKUP(B2:B7,$E$2:$F$4,2,FALSE)` in C2 alone is fine in Excel 365: it spills six results. Just don't fill it down as well.
- Formulas from older workbooks that relied on picking the value from the same row may now spill. Excel adds @ to them to keep the old behavior.
- Inside an Excel Table, use `[@Agent]` for the value on the same row.

## Questions

**Can one formula fill the whole column?**

Yes, in Excel 365: `=VLOOKUP(B2:B7,$E$2:$F$4,2,FALSE)` in C2 only, with the cells below empty. Google Sheets needs ARRAYFORMULA around it.

**Why did this work in older Excel?**

Older Excel quietly used only the value on the same row (implicit intersection). Excel 365 returns every value instead.

**Why do I still get #SPILL! from a formula that should spill?**

Something is in the way: any value in the cells the result needs (C3:C7 here) blocks it. Clear those cells.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/vlookup-returns-spill-error