How Do I Resolve The #SPILL! error?
I am trying to create a spreadsheet that can tally up multiple number for different items required in one job and have a reorder trigger.
When I am asking the formula to check more than one column I get the #SPILL! error and haven't a clue why or what I am missing.
Any help would be much appreciated.
Maybe just make the formula consistent with all the other formulae in the column? You are creating an array comparison, hence the desire to SPILL the results ... but it can't because there are other formulae below that cell.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try a simpler formula
=IF(MATCH(C7,D15:E15,FALSE)>0,D7-D25-E25)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks