identify multiple catagories with multiple key words

[Tinasloan]

I need to catagorize apx 5000 lines in to catagories 19 in all such as abrasives, tools, plumbing. by finding 650 key words in the description line of the sheet is there a function that will do this?

 

[Matty]

<table style="width: 434pt; border-collapse: collapse;" width="578" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt; height: 15pt;" width="149" height="20">

<table style="width: 434pt; border-collapse: collapse;" width="578" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt; height: 15pt;" width="149" height="20">Adhesives, Sealants, Tape & Painting</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt;" width="149">Chemicals</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt;" width="149">Electrical </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 98pt;" width="131">Foundry Supplies & Equipment</td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Glue</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">fuels</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Batteries</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Brick</td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Adhesive</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Acid</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Battery </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Crucibles</td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Threadlocking</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Caustic</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Enclosures</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Insulators</td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Componant</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Grease</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">enclosure </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">crucible </td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Caulk</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Fluids</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Junction </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Insulators</td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">Guns</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Release </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">junction-box</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Insulator </td></tr><tr style="height: 15pt;" height="20"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 15pt;" height="20">coat</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">penetrating </td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Metallic-boxes</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent;">Ladles</td></tr></tbody></table>

This is a partial of the table row 1 is the catagory listed down the column is the key word

This is a row from the actual spreadsheet I need to search column F that contains the part number description and return the rusult in column C
<table style="width: 781pt; border-collapse: collapse;" width="1040" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width: 95pt;" width="127"><col style="width: 98pt;" width="130" span="3"><col style="width: 86pt;" width="115"><col style="width: 306pt;" width="408"></colgroup><tbody><tr style="height: 21pt;" height="28"><td class="xl63" style="border: 0.5pt solid windowtext; background-color: rgb(255, 255, 204); width: 95pt; height: 21pt;" width="127" height="28">72340</td><td class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: rgb(255, 255, 204); width: 98pt;" width="130">31162800</td><td class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: rgb(255, 255, 204); width: 98pt;" width="130">Hardware & Fasteners</td><td class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: rgb(255, 255, 204); width: 98pt;" width="130">Hardware</td><td class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: rgb(255, 255, 204); width: 86pt;" width="115">None</td><td class="xl64" style="border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: windowtext; background-color: rgb(255, 255, 204); width: 306pt;" width="408">REMOVAL & TAPPING TOOL 1/4-28 1080K21</td></tr></tbody></table>

</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt;" width="149">
</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 112pt;" width="149">
</td><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 98pt;" width="131">
</td></tr></tbody></table>Hi,

Could you elaborate further, please? Is it that you want the header returned to Column C if any of the elements below the headers exist in Column F?

Matty

 

[Tinasloan]

Yes exactly

 

[Matty]

There might be a better way, but this works:

<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 213px;"><col style="width: 70px;"><col style="width: 179px;"><col style="width: 179px;"><col style="width: 35px;"><col style="width: 251px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td>
</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="font-family: Calibri;">Adhesives, Sealants, Tape & Painting</td><td style="font-family: Calibri;">Chemicals</td><td style="font-family: Calibri;">Electrical </td><td style="font-family: Calibri;">Foundry Supplies & Equipment</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="font-family: Calibri;">Glue</td><td style="font-family: Calibri;">fuels</td><td style="font-family: Calibri;">Batteries</td><td style="font-family: Calibri;">Brick</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Calibri;">Adhesive</td><td style="font-family: Calibri;">Acid</td><td style="font-family: Calibri;">Battery </td><td style="font-family: Calibri;">Crucibles</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="font-family: Calibri;">Threadlocking</td><td style="font-family: Calibri;">Caustic</td><td style="font-family: Calibri;">Enclosures</td><td style="font-family: Calibri;">Insulators</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="font-family: Calibri;">Componant</td><td style="font-family: Calibri;">Grease</td><td style="font-family: Calibri;">enclosure </td><td style="font-family: Calibri;">crucible </td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="font-family: Calibri;">Caulk</td><td style="font-family: Calibri;">Fluids</td><td style="font-family: Calibri;">Junction </td><td style="font-family: Calibri;">Insulators</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="font-family: Calibri;">Guns</td><td style="font-family: Calibri;">Release </td><td style="font-family: Calibri;">junction-box</td><td style="font-family: Calibri;">Insulator </td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td style="font-family: Calibri;">coat</td><td style="font-family: Calibri;">penetrating </td><td style="font-family: Calibri;">Metallic-boxes</td><td style="font-family: Calibri;">Ladles</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">11</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri; text-align: right;">72340</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri; text-align: right;">31162800</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri;">Foundry Supplies & Equipment</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri;">Hardware</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri;">None</td><td style="background-color: rgb(255, 255, 204); font-family: Calibri;">Crucibles 1/4-28 1080K21</td></tr></tbody></table>
Formula in C11 is:

=INDEX(A1:D1,SMALL(IF(ISNUMBER(SEARCH(A2:D8,F11)),COLUMN(A1:D1)-COLUMN(A1)+1),1))

Which is an array formula and therefore needs committing with CTRL+SHIFT+ENTER.

Matty

 

[Tinasloan]

<TABLE style="WIDTH: 931pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1239><COLGROUP><COL style="WIDTH: 205pt; mso-width-source: userset; mso-width-alt: 9984" width=273><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 7533" width=206><COL style="WIDTH: 164pt; mso-width-source: userset; mso-width-alt: 7972" width=218><COL style="WIDTH: 157pt; mso-width-source: userset; mso-width-alt: 7643" width=209><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 202pt; mso-width-source: userset; mso-width-alt: 9837" width=269><TBODY><TR style="HEIGHT: 45.75pt; mso-height-source: userset" height=61><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 45.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=61 width=273>Adhesives, Sealants, Tape & Painting</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" id=td_post_2680174 class=xl63 width=206>Chemicals</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Electrical</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Foundry Supplies & Equipment</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=20 width=273>Glue</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>fuels</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Batteries</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Brick</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=20 width=273>Adhesive</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>Acid</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Battery</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Crucibles</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=34 width=273>Threadlocking</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>Caustic</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Enclosures</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Insulators</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=34 width=273>Componant</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>Grease</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>enclosure</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>crucible</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=20 width=273>Caulk</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>Fluids</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Junction</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Insulators</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=34 width=273>Guns</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>Release</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>junction-box</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Insulator</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=34 width=273>coat</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=206>penetrating</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=218>Metallic-boxes</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 width=209>Ladles</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=20 width=273> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=206> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=218> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=209> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 205pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=20 width=273> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=206> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 164pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=218> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=209> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl67 width=269> </TD></TR><TR style="HEIGHT: 63.75pt; mso-height-source: userset" height=85><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 205pt; HEIGHT: 63.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=85 width=273>72340</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 155pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=206>31162800</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: #f0f0f0" class=xl69>Electrical

</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 157pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" id=td_post_2680174 class=xl66 width=209>Hardware</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>None</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 202pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl68 width=269>Crucibles 1/4-28 1080K21</TD></TR></TBODY></TABLE>
=INDEX(A1:D1,SMALL(IF(ISNUMBER(SEARCH(A2:D8,F11)),COLUMN(A1:D1)-COLUMN(A1)+1),1))
It returns the wrong value