Hi all, Im doing a project is that, when you enter quantity for that product code (around 20 components to build a unit), it would return the quantities of its components. so what formula that i should use in this case? and can i turn the sheet to a simple web app?

thank you so much