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))))

Thank you