EXCEL ASSIS

pgonz2403 

First of all, that deeply nested IFERROR(IF.... formula is a nightmare waiting to happen. I hope that's why you've come here. Yesterday I came across this "Rule of Thumb" for formulas in a blog by one of the true experts in this forum. I saved it for use at times like this:

Second, what's the relationship between the date in cell $C$2 and the available inventory? I ask because there are no dates (or no dates visible) in the data table itself, so no dates to compare with $C$2. Perhaps it's just the OnHand column, but if that's the case, you don't really need a date as reference in the formula.

Third, rather than an image, would you be so kind as to post an actual copy of the spreadsheet itself. Images don't lend themselves to formula creation.

If  you use the "Open Full Text Editor" feature, you should see an area for dragging and dropping a file.  If that doesn't work for you, post it on OneDrive or GoogleDrive and paste a link here that grants access.