Forum Discussion

Copper Contributor

Feb 01, 2020

Solved

Excell #SPILL! Error using =VLOOKUP

Hi all! I am having an issue with an Excel spreadsheet linked to another sheet with data inside a workbook. I have contacted my teacher in relation to this problem and sent through my workbook, h...

MF_1.xlsm27 KB

excel

Detlef_Lewin
Feb 01, 2020
_Ness_1
I could not find your formula in the workbook. So I'm guessing it would have been in sheet Summary cell I4.
At least that is where I get a #SPILL! error. Click here for the reason.
In your case the formula should be:
=VLOOKUP([@PledgeCode],DonationTable,2)

And most of your named ranges are more or less obsolete because with Excel Tables you get structured references (like @PledgeCode) and you can add a total row (no extra formula outside the table is needed).

Detlef_Lewin

Silver Contributor

Feb 01, 2020

_Ness_1

I could not find your formula in the workbook. So I'm guessing it would have been in sheet Summary cell I4.

At least that is where I get a #SPILL! error. Click here for the reason.

In your case the formula should be:

=VLOOKUP([@PledgeCode],DonationTable,2)

And most of your named ranges are more or less obsolete because with Excel Tables you get structured references (like @PledgeCode) and you can add a total row (no extra formula outside the table is needed).