Reference Row Data from another Sheet

[RRidenour]

I've tried searches, but I'm not sure if I'm using the correct search terms...

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 for the cut length.

DRIVE TUBES.xlsx

[Pete_UK]

Welcome to the forum.

It would be better for you to attach a sample Excel workbook, rather than pictures of what you have, and then we will be able to see what sheet names you are using and the column and row references that are used. To do this, follow the guidelines given in the yellow banner at the top of the screen.

Hope this helps.

Pete

[RRidenour]

Done. Thanks for the tip.

[JeteMc]

This seems to work for the sample provided:
1. Paste the following into cell C2:

Please Login or Register  to view this content.

2. Drag the fill handle down to cell C5 and then, while cells C2:C5 are still selected, drag the fill handle over to cell D5
Let us know if you have any questions.