Is it possible to pull data from a second sheet and have it auto-fill without having to tell it specifically what to fill for? I know that's poorly worded but I don't know how to word it concisely.
I'm trying to create material cut sheets fed from a work order spreadsheet. Cut lengths vary and I would need one cut sheet per length that is actually used, and also list the order numbers that use that length with their quantities needed. I thought I remembered there was a way to pull only the sizes used using VLOOKUP but it keeps pulling every length, even the ones without a quantity next to them. Am I remembering a dream? Can this even be done?
Below is an example of the two tables I need to pull the data from. We use SEQ for the order number.
<tbody>
</tbody>
Here is table 2
<tbody>
</tbody>
I'm trying to create material cut sheets fed from a work order spreadsheet. Cut lengths vary and I would need one cut sheet per length that is actually used, and also list the order numbers that use that length with their quantities needed. I thought I remembered there was a way to pull only the sizes used using VLOOKUP but it keeps pulling every length, even the ones without a quantity next to them. Am I remembering a dream? Can this even be done?
Below is an example of the two tables I need to pull the data from. We use SEQ for the order number.
TABLE #1 FLAT SHEET LINE | ||
SHEET TOTAL | SHEET | |
63 | 96 | x 48 |
159 | 90 | x 48 |
251 | 84 | x 48 |
67 | 78 | x 48 |
69 | 72 | x 48 |
66 | x 48 | |
609 | TOTAL SHT | |
3,867.50 | Linear Ft. |
<tbody>
</tbody>
Here is table 2
SEQ# | # PARTS | # SHEETS | SHEET | |
1029 | 400 | 67 | 84 | x 48 |
1030 | 400 | 67 | 84 | x 48 |
1031 | 1100 | 69 | 72 | x 48 |
1032 | 700 | 117 | 84 | x 48 |
1033 | 800 | 67 | 78 | x 48 |
1034 | 950 | 159 | 90 | x 48 |
1035 | 1000 | 63 | 96 | x 48 |
<tbody>
</tbody>
Last edited: