Forum Discussion
Production schedule
Hey everyone, I'm trying to make a production schedule that will allow me to enter an item number and a quantity of raw material (for the factory), which will calculate the quantity of product th...
You're asking us to visualize a lot here....is it possible for you to post a copy or a mock-up of what you are trying to describe. Not a picture, an Excel workbook with samples of the data you're going to be working with. If the actuals are confidential, then a mock-up without reference to reality except in the layout.
That aside, if you want to do a little research on your own, Excel offers several ways to access a table with data on any given entity. So check out VLOOKUP, INDEX and MATCH used together, and/or XLOOKUP. Here's a link to a website that describes how XLOOKUP works. It might be what you're looking for.
https://exceljet.net/excel-functions/excel-xlookup-function