Hey Everyone,

I have an issue where I have set up a sheet that manages the parts needed for each SKU or product that We make. The Problem is that for some reason the sheet is pulling the SKU's now but its telling me the part number to some but not the others and I cant figure out why. I am trying to get it to tell me the amount of parts i will need for each SKU so I can correctly order what I actually need instead of guessing.

An example:
This is the product description I use to build the product
Desktop.PNG

This is a SKU inside the description:
SKU.PNG

These are the parts to Build that SKU:
Parts.PNG

Then its suppose to add the parts here:
SUM.PNG

The Problem is, its not adding them to the list. Not exactly sure what's going on because some are working and some aren't.

HLS Parts and Quantity_10202022.xlsx