Forum Discussion
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...
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).
Hi,
It seems to be some issues with new Dynamic Arrays and Excel Tables.
You can fix that by converting the table qryfundraiser__2 in the Summary sheet to a normal range!
Or use a single value in lookup_value in VLOOKUP instead of the whole column as follows:
=VLOOKUP(H4,DonationTable,2,0)
Regards
Thank-you so much Haytham Amairah It works!