My company manufacturers a product line with variations of length. I have a workbook with a sheet for production that shows cut-lengths and quantities. It has another sheet with a complete list of part numbers and required cut-lengths for each. In some cases, there are multiple part numbers with the same length. I want to enter the part number in the production sheet and have it automatically populate the cut length from the corresponding row on the part number sheet.
How can I link a cell to include data from the cut-length column on the part number sheet based on the part number that is entered on the production sheet?
For example, if I enter "AA", "BA", or "CA" in the production sheet, I want it to automatically show "47 5/8" from the DIM B column.
Part Number Sheet