Forum Discussion
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, he replied that his excel was able to complete the formulae with no issues. I've re-installed Microsoft Office and I'm still having the result #SPILL! Down the donation column.
The formulae is =VLOOKUP(PledgeCode,DonationTable,2)
I have attached the workbook MF_1 as well.
Any help would be greatly appreciated.
Ness.
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).
4 Replies
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).
Oh wow! Thankyou so much Detlef_Lewin This one works as well 🙂
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!
