Advanced Index Match and Rows Problems... All Have Failed Who have tried this. Can you Please Help.

[Kryticalmazz]

I've had about 8 people who claim to be Excel experts try this and are really just making it worst.

Issues:

I need a formula that will group parts (Part Number, Description, and PO Number) based on their specific alloys within a column. Each Column represents Part Number, Description, Alloy, and PO Number. Each alloy has a specific worksheet within the workbook. Part Number, Description, Quantities, and PO Number for each part that has that alloy need to transfer to the specific alloy worksheet. The The formulas used on "Packing" page can be ignored, but all transfers need to come from the "Packing" worksheet.

Packing

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 71px"><COL style="WIDTH: 122px"><COL style="WIDTH: 198px"><COL style="WIDTH: 79px"><COL style="WIDTH: 99px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">QTY</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Part Number</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Description</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Alloy</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Purchase Order #</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">41</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">B20622</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Gland</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF8M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">20622H</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Spares</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF8M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">40044/2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Clutch</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF8M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">111</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">177276</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Outside Link</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF3M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">4444</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">177275</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Inside Link</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF3M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">1139RC</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; TEXT-ALIGN: center">Port Plate</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">CF8M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right">74</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 9pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C18</TD><TD>=IF(B18="","",(VLOOKUP(B18,'Data Sheet'!A73:B1652,2,FALSE)))</TD></TR><TR><TD>C19</TD><TD>=IF(B19="","",(VLOOKUP(B19,'Data Sheet'!A74:B1653,2,FALSE)))</TD></TR><TR><TD>C20</TD><TD>=IF(B20="","",(VLOOKUP(B20,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR><TR><TD>C21</TD><TD>=IF(B21="","",(VLOOKUP(B21,'Data Sheet'!A73:B1652,2,FALSE)))</TD></TR><TR><TD>C22</TD><TD>=IF(B22="","",(VLOOKUP(B22,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR><TR><TD>C23</TD><TD>=IF(B23="","",(VLOOKUP(B23,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR><TR><TD>C24</TD><TD>=IF(B24="","",(VLOOKUP(B24,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR><TR><TD>C25</TD><TD>=IF(B25="","",(VLOOKUP(B25,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR><TR><TD>C26</TD><TD>=IF(B26="","",(VLOOKUP(B26,'Data Sheet'!A72:B1651,2,FALSE)))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Here is the page that is alloy specific. The only problem is when the alloys are not in ascending or descending order they don't transfer the right description, quantities and part numbers.

MTR 1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 49px"><COL style="WIDTH: 59px"><COL style="WIDTH: 46px"><COL style="WIDTH: 46px"><COL style="WIDTH: 55px"><COL style="WIDTH: 45px"><COL style="WIDTH: 44px"><COL style="WIDTH: 47px"><COL style="WIDTH: 44px"><COL style="WIDTH: 44px"><COL style="WIDTH: 48px"><COL style="WIDTH: 55px"><COL style="WIDTH: 49px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: left" colSpan=2>Customer: </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Cooper Valves</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right" colSpan=2>Total Items:</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">4</TD><TD></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">Alloy:</TD><TD style="FONT-WEIGHT: bold" colSpan=2></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">CF8M</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right" colSpan=2>Heat No:</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt" colSpan=2></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Date:</TD><TD style="FONT-WEIGHT: bold" colSpan=2></TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt">Chemical Analysis</TD><TD style="FONT-SIZE: 14pt"></TD><TD style="FONT-SIZE: 14pt"></TD><TD style="FONT-SIZE: 14pt"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">C</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">P</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">S</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">NI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CR</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CU</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CO</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MO</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">W</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">FE</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">N</TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD></TR><TR style="HEIGHT: 26px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CBTA</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">V</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">B</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">PB</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">ZR</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SE</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">AL</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MG</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">TI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">ZN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">NB</TD></TR><TR style="HEIGHT: 30px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD></TR><TR style="HEIGHT: 11px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 32px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt">Mechanical Test</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: left">Tensile</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Yield</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=2>Elongation</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Reduction</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=3>Hardness</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Strength (psi)</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=3>Strenghth (psi)</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">(2") %</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">of Area %</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: center">??</TD><TD style="FONT-SIZE: 12pt"></TD></TR><TR style="HEIGHT: 29px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD colSpan=2></TD><TD colSpan=3></TD><TD colSpan=2></TD><TD colSpan=3></TD><TD colSpan=3></TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD></TD><TD colSpan=2></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 26px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD></TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">#</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">P.O. Number</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">Part Number</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">Description</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center" colSpan=2>Quantity</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">B20622</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Gland</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">41</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">20622H</TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Spares</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">40044/2</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Clutch</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">14</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">177276</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Outside Link</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">111</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 7px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C9</TD><TD>=RealB10</TD></TR><TR><TD>L9</TD><TD>=COUNTIF(Packing!$D$18:$D$33,D10)</TD></TR><TR><TD>L10</TD><TD>=IF(RealF10<>"",RealF10,"")</TD></TR><TR><TD>A24</TD><TD>=IF(ROWS(A$23:A23)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A23):Packing!$D$33,0)+A23,0)</TD></TR><TR><TD>D24</TD><TD>=IF($A24,INDEX(Packing!E$18:E$33,$A24),"")</TD></TR><TR><TD>G24</TD><TD>=IF($A24,INDEX(Packing!B$18:B$33,$A24),"")</TD></TR><TR><TD>J24</TD><TD>=IF($A24,INDEX(Packing!C$18:C$33,$A24),"")</TD></TR><TR><TD>L24</TD><TD>=IF($A24,INDEX(Packing!A$18:A$33,$A24),"")</TD></TR><TR><TD>A25</TD><TD>=IF(ROWS(A$23:A24)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A24):Packing!$D$33,0)+A24,0)</TD></TR><TR><TD>D25</TD><TD>=IF($A25,INDEX(Packing!E$18:E$33,$A25),"")</TD></TR><TR><TD>G25</TD><TD>=IF($A25,INDEX(Packing!B$18:B$33,$A25),"")</TD></TR><TR><TD>J25</TD><TD>=IF($A25,INDEX(Packing!C$18:C$33,$A25),"")</TD></TR><TR><TD>L25</TD><TD>=IF($A25,INDEX(Packing!A$18:A$33,$A25),"")</TD></TR><TR><TD>A26</TD><TD>=IF(ROWS(A$23:A25)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A25):Packing!$D$33,0)+A25,0)</TD></TR><TR><TD>D26</TD><TD>=IF($A26,INDEX(Packing!E$18:E$33,$A26),"")</TD></TR><TR><TD>G26</TD><TD>=IF($A26,INDEX(Packing!B$18:B$33,$A26),"")</TD></TR><TR><TD>J26</TD><TD>=IF($A26,INDEX(Packing!C$18:C$33,$A26),"")</TD></TR><TR><TD>L26</TD><TD>=IF($A26,INDEX(Packing!A$18:A$33,$A26),"")</TD></TR><TR><TD>A27</TD><TD>=IF(ROWS(A$23:A26)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A26):Packing!$D$33,0)+A26,0)</TD></TR><TR><TD>D27</TD><TD>=IF($A27,INDEX(Packing!E$18:E$33,$A27),"")</TD></TR><TR><TD>G27</TD><TD>=IF($A27,INDEX(Packing!B$18:B$33,$A27),"")</TD></TR><TR><TD>J27</TD><TD>=IF($A27,INDEX(Packing!C$18:C$33,$A27),"")</TD></TR><TR><TD>L27</TD><TD>=IF($A27,INDEX(Packing!A$18:A$33,$A27),"")</TD></TR><TR><TD>A28</TD><TD>=IF(ROWS(A$23:A27)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A27):Packing!$D$33,0)+A27,0)</TD></TR><TR><TD>D28</TD><TD>=IF($A28,INDEX(Packing!E$18:E$33,$A28),"")</TD></TR><TR><TD>G28</TD><TD>=IF($A28,INDEX(Packing!B$18:B$33,$A28),"")</TD></TR><TR><TD>J28</TD><TD>=IF($A28,INDEX(Packing!C$18:C$33,$A28),"")</TD></TR><TR><TD>L28</TD><TD>=IF($A28,INDEX(Packing!A$18:A$33,$A28),"")</TD></TR><TR><TD>A29</TD><TD>=IF(ROWS(A$23:A28)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A28):Packing!$D$33,0)+A28,0)</TD></TR><TR><TD>D29</TD><TD>=IF($A29,INDEX(Packing!E$18:E$33,$A29),"")</TD></TR><TR><TD>G29</TD><TD>=IF($A29,INDEX(Packing!B$18:B$33,$A29),"")</TD></TR><TR><TD>J29</TD><TD>=IF($A29,INDEX(Packing!C$18:C$33,$A29),"")</TD></TR><TR><TD>L29</TD><TD>=IF($A29,INDEX(Packing!A$18:A$33,$A29),"")</TD></TR><TR><TD>A30</TD><TD>=IF(ROWS(A$23:A29)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A29):Packing!$D$33,0)+A29,0)</TD></TR><TR><TD>D30</TD><TD>=IF($A30,INDEX(Packing!E$18:E$33,$A30),"")</TD></TR><TR><TD>G30</TD><TD>=IF($A30,INDEX(Packing!B$18:B$33,$A30),"")</TD></TR><TR><TD>J30</TD><TD>=IF($A30,INDEX(Packing!C$18:C$33,$A30),"")</TD></TR><TR><TD>L30</TD><TD>=IF($A30,INDEX(Packing!A$18:A$33,$A30),"")</TD></TR><TR><TD>A31</TD><TD>=IF(ROWS(A$23:A30)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A30):Packing!$D$33,0)+A30,0)</TD></TR><TR><TD>D31</TD><TD>=IF($A31,INDEX(Packing!E$18:E$33,$A31),"")</TD></TR><TR><TD>G31</TD><TD>=IF($A31,INDEX(Packing!B$18:B$33,$A31),"")</TD></TR><TR><TD>J31</TD><TD>=IF($A31,INDEX(Packing!C$18:C$33,$A31),"")</TD></TR><TR><TD>L31</TD><TD>=IF($A31,INDEX(Packing!A$18:A$33,$A31),"")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Here is the second alloy page.

MTR 2

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 49px"><COL style="WIDTH: 59px"><COL style="WIDTH: 46px"><COL style="WIDTH: 46px"><COL style="WIDTH: 55px"><COL style="WIDTH: 45px"><COL style="WIDTH: 44px"><COL style="WIDTH: 47px"><COL style="WIDTH: 44px"><COL style="WIDTH: 44px"><COL style="WIDTH: 48px"><COL style="WIDTH: 55px"><COL style="WIDTH: 49px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: left" colSpan=2>Customer: </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Cooper Valves</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right" colSpan=2>Total Items:</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">2</TD><TD></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">Alloy:</TD><TD style="FONT-WEIGHT: bold" colSpan=2></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">CF3M</TD><TD style="FONT-WEIGHT: bold"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: right" colSpan=2>Heat No:</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt" colSpan=2></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Date:</TD><TD style="FONT-WEIGHT: bold" colSpan=2></TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt">Chemical Analysis</TD><TD style="FONT-SIZE: 14pt"></TD><TD style="FONT-SIZE: 14pt"></TD><TD style="FONT-SIZE: 14pt"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">C</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">P</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">S</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">NI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CR</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CU</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CO</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MO</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">W</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">FE</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">N</TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD></TR><TR style="HEIGHT: 26px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">CBTA</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">V</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">B</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">PB</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">M</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">ZR</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SE</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">AL</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">MG</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">SN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">TI</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">ZN</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">NB</TD></TR><TR style="HEIGHT: 30px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-SIZE: 9pt"></TD></TR><TR style="HEIGHT: 11px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 32px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt">Mechanical Test</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: left">Tensile</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Yield</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=2>Elongation</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Reduction</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=3>Hardness</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Strength (psi)</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center" colSpan=3>Strenghth (psi)</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">(2") %</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">of Area %</TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt"></TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: center">??</TD><TD style="FONT-SIZE: 12pt"></TD></TR><TR style="HEIGHT: 29px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD colSpan=2></TD><TD colSpan=3></TD><TD colSpan=2></TD><TD colSpan=3></TD><TD colSpan=3></TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD></TD><TD colSpan=2></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 26px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD></TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">#</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">P.O. Number</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">Part Number</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: left">Description</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center" colSpan=2>Quantity</TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">177276</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Outside Link</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">111</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">74</TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">177275</TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Inside Link</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4444</TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 21px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 14pt; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 7px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C9</TD><TD>=RealB10</TD></TR><TR><TD>L9</TD><TD>=COUNTIF(Packing!$D$18:$D$33,D10)</TD></TR><TR><TD>L10</TD><TD>=IF(RealF10<>"",RealF10,"")</TD></TR><TR><TD>A24</TD><TD>=IF(ROWS(A$23:A23)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A23):Packing!$D$33,0)+A23,0)</TD></TR><TR><TD>D24</TD><TD>=IF($A24,INDEX(Packing!E$18:E$33,$A24),"")</TD></TR><TR><TD>G24</TD><TD>=IF($A24,INDEX(Packing!B$18:B$33,$A24),"")</TD></TR><TR><TD>J24</TD><TD>=IF($A24,INDEX(Packing!C$18:C$33,$A24),"")</TD></TR><TR><TD>L24</TD><TD>=IF($A24,INDEX(Packing!A$18:A$33,$A24),"")</TD></TR><TR><TD>A25</TD><TD>=IF(ROWS(A$23:A24)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A24):Packing!$D$33,0)+A24,0)</TD></TR><TR><TD>D25</TD><TD>=IF($A25,INDEX(Packing!E$18:E$33,$A25),"")</TD></TR><TR><TD>G25</TD><TD>=IF($A25,INDEX(Packing!B$18:B$33,$A25),"")</TD></TR><TR><TD>J25</TD><TD>=IF($A25,INDEX(Packing!C$18:C$33,$A25),"")</TD></TR><TR><TD>L25</TD><TD>=IF($A25,INDEX(Packing!A$18:A$33,$A25),"")</TD></TR><TR><TD>A26</TD><TD>=IF(ROWS(A$23:A25)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A25):Packing!$D$33,0)+A25,0)</TD></TR><TR><TD>D26</TD><TD>=IF($A26,INDEX(Packing!E$18:E$33,$A26),"")</TD></TR><TR><TD>G26</TD><TD>=IF($A26,INDEX(Packing!B$18:B$33,$A26),"")</TD></TR><TR><TD>J26</TD><TD>=IF($A26,INDEX(Packing!C$18:C$33,$A26),"")</TD></TR><TR><TD>L26</TD><TD>=IF($A26,INDEX(Packing!A$18:A$33,$A26),"")</TD></TR><TR><TD>A27</TD><TD>=IF(ROWS(A$23:A26)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A26):Packing!$D$33,0)+A26,0)</TD></TR><TR><TD>D27</TD><TD>=IF($A27,INDEX(Packing!E$18:E$33,$A27),"")</TD></TR><TR><TD>G27</TD><TD>=IF($A27,INDEX(Packing!B$18:B$33,$A27),"")</TD></TR><TR><TD>J27</TD><TD>=IF($A27,INDEX(Packing!C$18:C$33,$A27),"")</TD></TR><TR><TD>L27</TD><TD>=IF($A27,INDEX(Packing!A$18:A$33,$A27),"")</TD></TR><TR><TD>A28</TD><TD>=IF(ROWS(A$23:A27)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A27):Packing!$D$33,0)+A27,0)</TD></TR><TR><TD>D28</TD><TD>=IF($A28,INDEX(Packing!E$18:E$33,$A28),"")</TD></TR><TR><TD>G28</TD><TD>=IF($A28,INDEX(Packing!B$18:B$33,$A28),"")</TD></TR><TR><TD>J28</TD><TD>=IF($A28,INDEX(Packing!C$18:C$33,$A28),"")</TD></TR><TR><TD>L28</TD><TD>=IF($A28,INDEX(Packing!A$18:A$33,$A28),"")</TD></TR><TR><TD>A29</TD><TD>=IF(ROWS(A$23:A28)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A28):Packing!$D$33,0)+A28,0)</TD></TR><TR><TD>D29</TD><TD>=IF($A29,INDEX(Packing!E$18:E$33,$A29),"")</TD></TR><TR><TD>G29</TD><TD>=IF($A29,INDEX(Packing!B$18:B$33,$A29),"")</TD></TR><TR><TD>J29</TD><TD>=IF($A29,INDEX(Packing!C$18:C$33,$A29),"")</TD></TR><TR><TD>L29</TD><TD>=IF($A29,INDEX(Packing!A$18:A$33,$A29),"")</TD></TR><TR><TD>A30</TD><TD>=IF(ROWS(A$23:A29)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A29):Packing!$D$33,0)+A29,0)</TD></TR><TR><TD>D30</TD><TD>=IF($A30,INDEX(Packing!E$18:E$33,$A30),"")</TD></TR><TR><TD>G30</TD><TD>=IF($A30,INDEX(Packing!B$18:B$33,$A30),"")</TD></TR><TR><TD>J30</TD><TD>=IF($A30,INDEX(Packing!C$18:C$33,$A30),"")</TD></TR><TR><TD>L30</TD><TD>=IF($A30,INDEX(Packing!A$18:A$33,$A30),"")</TD></TR><TR><TD>A31</TD><TD>=IF(ROWS(A$23:A30)<=$L$9,MATCH($D$10,INDEX(Packing!$D$18:$D$33,A30):Packing!$D$33,0)+A30,0)</TD></TR><TR><TD>D31</TD><TD>=IF($A31,INDEX(Packing!E$18:E$33,$A31),"")</TD></TR><TR><TD>G31</TD><TD>=IF($A31,INDEX(Packing!B$18:B$33,$A31),"")</TD></TR><TR><TD>J31</TD><TD>=IF($A31,INDEX(Packing!C$18:C$33,$A31),"")</TD></TR><TR><TD>L31</TD><TD>=IF($A31,INDEX(Packing!A$18:A$33,$A31),"")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

In cell D10 the alloy is selected from a drop down list. This is what tells the sheet what alloy it's looking for. As you can see the descriptions and other info do not transfer as they are listed on the worksheet titled "Packing" because the CF8M is Not grouped in the column with the other CF8M's.


This has really been a headache for me. I don't have a lot of computer programming background. I am an engineer that really just needs this to work. If you can help. I owe you a hundred thank you's.

 

[RolfJ]

Wow! This is quite a complex workbook! Did you develop the VLOOKUP formulae yourself?

I couldn't help tripping over a remark you made near the top of your post:

'The only problem is when the alloys are not in ascending or descending order they don't transfer the right description, quantities and part numbers.'

Are you sure about this conclusion? When the 'Range_Lookup' parameter (the last one in the the VLOOKUP function) is set to FALSE the array does not need to be sorted. What I noticed though was the there was an apparent inconsistency in the array reference in the first set of formulae you shared in your post. The third and the last five formulae are referencing the range A72:B1651, but the others are referencing a range that's offset by one or two rows. Is that intended?

Probably not much help, but I thought I should share this observation anyhow.

Good luck,
Rolf

 

[Kryticalmazz]

yeah..the VLOOKUP is not the problem. It actually works without fail. All it does is pull part descriptions from a data sheet using the part number.

The problem is transfering what is on that packing list to the alloy specific worksheets.

Thanks.

 

[RolfJ]

I think I got the solution to your problem. Here goes:

1. In your alloy-specific worksheets (MTR1 etc.) delete all formulae from row 24 on down.
2. Enter the following formulae into your alloy-specific worksheets:
   
   Cell A24:
   

   =IF(ISNA(MATCH($D$10,Packing!D18:D23,0)),"",MATCH($D$10,Packing!D18:D23,0))

   
   Cell A25:
   

   =IF(A24<>"",IF(ISNA(MATCH($D$10,OFFSET(Packing!D$18:D$23,A24,0,6,1),0)),"",MATCH($D$10,OFFSET(Packing!D$18:D$23,A24,0,6,1),0)+A24),"")

   Copy this formula to the cells below A25 as far down as you think you might need it.
   
   Cell B24:
   

   =IF(A24<>"",A24,"")

   
   Cell B25:
   

   =IF($A25<>"",B24+1,"")

   Copy this formula to the cells below B25 as far down as you think you might need it.
   
   
   
   Cell D24: =IF($A24<>"",INDEX(Packing!E$18:E$23,$A24),"")
3. 
   Cell G24:

 

[RolfJ]

Something went wrong with my previous response. Here is the rest of the solution:

Cell G24:

=IF($A24<>"",INDEX(Packing!B$18:B$33,$A24),"")

Copy this formula to the cells below G24 as far down as you think you might need it.

Cell J24:

=IF($A24<>"",INDEX(Packing!C$18:C$33,$A24),"")

Copy this formula to the cells below J24 as far down as you think you might need it.

Cell L24:

=IF($A24<>"",INDEX(Packing!A$18:A$33,$A24),"")

Please don't hesitate to let me know if you have further questions.

Hope this helped,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com

Phone: 800.580.0068
Cell: 510.300.7462