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

K

Kryticalmazz

New Member
Joined
Sep 9, 2009
Messages
10
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.
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
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
 
Upvote 0
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.
 
Upvote 0
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:
    Code: 
    =IF(ISNA(MATCH($D$10,Packing!D18:D23,0)),"",MATCH($D$10,Packing!D18:D23,0))

    Cell A25:
    Code: 
    =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:
    Code: 
    =IF(A24<>"",A24,"")

    Cell B25:
    Code: 
    =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:
 
Upvote 0
Something went wrong with my previous response. Here is the rest of the solution:

Cell G24:
Code: 
=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:
Code: 
=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:
Code: 
=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
 
Last edited by a moderator:
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
437
Micron
M
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
354
esben
E
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
843
gvsumich
G
E
  • Question
Create mails with table - standard header specific row
Replies
1
Views
952
esben
E

Forum statistics

Threads
1,215,155
Messages
6,123,331
Members
449,098
Latest member
thnirmitha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top