The following formula is failing to return any stock value if the first stock item in column B is zero. If anyone can help to correct it that would be great.
=IF(IF(ISERROR(VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)),0,
IF(VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)-SUMIF($H$7:$H7,$H8,$E$7:$E7)>E8,E8,
VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)-SUMIF($H$7:$H7,$H8,$E$7:$E7)))<0,0,
IF(ISERROR(VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)),0,
IF(VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)-SUMIF($H$7:$H7,$H8,$E$7:$E7)>E8,E8,
VLOOKUP(H8,Stock!$A$2:$B$23,2,FALSE)-SUMIF($H$7:$H7,$H8,$E$7:$E7))))
Bookmarks