Vlookup or something, cant figure out how to do this?

[nickgreening]

Guys,

please could i have your help? I think i can use Vlookup to find and fill out the outputs in the table below, but how to add the logical functions, as there so many?

the first table is the table that i'm creating and the second table is the reference table that i have been given and i'm taking the data from, the items that need to checked that have to be the same are labeled a to f and the outputs are numbered 1 to 6.

thanks for the help!

table 1


<link rel=File-List href="example1_1_files/filelist.xml">
<style id="example1_1_13617_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl6413617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6513617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:11.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl6613617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl6713617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl6813617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
background:#0070C0;
mso-pattern:black none;
white-space:normal;}
.xl6913617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7013617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:top;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7113617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:top;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:1.0pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7213617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7313617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:top;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7413617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#92D050;
mso-pattern:black none;
white-space:normal;}
.xl7513617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:red;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#92D050;
mso-pattern:black none;
white-space:normal;}
.xl7613617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:red;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#92D050;
mso-pattern:black none;
white-space:normal;}
.xl7713617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
background:red;
mso-pattern:black none;
white-space:normal;}
.xl7813617
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#F79646;
mso-pattern:black none;
white-space:normal;}
-->
</style>
</head>

<body>
<!--[if !excel]>  <![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="example1_1_13617" align=center xublishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=1480 class=xl6413617
style='border-collapse:collapse;table-layout:fixed;width:1120pt'>
<col class=xl6713617 width=74 span=3 style='mso-width-source:userset;
mso-width-alt:2706;width:56pt'>
<col class=xl6613617 width=74 style='mso-width-source:userset;mso-width-alt:
2706;width:56pt'>
<col class=xl6713617 width=74 span=2 style='mso-width-source:userset;
mso-width-alt:2706;width:56pt'>
<col class=xl6613617 width=74 style='mso-width-source:userset;mso-width-alt:
2706;width:56pt'>
<col class=xl6713617 width=74 style='mso-width-source:userset;mso-width-alt:
2706;width:56pt'>
<col class=xl6613617 width=74 span=2 style='mso-width-source:userset;
mso-width-alt:2706;width:56pt'>
<col class=xl6713617 width=74 span=3 style='mso-width-source:userset;
mso-width-alt:2706;width:56pt'>
<col class=xl6613617 width=74 span=7 style='mso-width-source:userset;
mso-width-alt:2706;width:56pt'>
<tr height=51 style='height:38.25pt'>
<td height=51 class=xl7413617 width=74 style='height:38.25pt;width:56pt'> </td>
<td colspan=10 class=xl7513617 width=740 style='border-right:.5pt solid black;
width:560pt'>FULL DESCRIPTION</td>
<td class=xl7513617 width=74 style='width:56pt'> </td>
<td class=xl6813617 width=74 style='width:56pt'> </td>
<td class=xl7713617 width=74 style='width:56pt'>SHORT DESCRIPTION</td>
<td colspan=6 class=xl7813617 width=444 style='width:336pt'>ADDITIONAL
INFORMATION</td>
</tr>
<tr height=34 style='height:25.5pt'>
<td height=34 class=xl6913617 width=74 style='height:25.5pt;border-top:none;
width:56pt'>PRODUCT</td>
<td class=xl7013617 width=74 style='border-top:none;width:56pt'>check a</td>
<td class=xl7113617 width=74 style='border-top:none;width:56pt'>check b</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>check c</td>
<td class=xl7313617 width=74 style='border-top:none;border-left:none;
width:56pt'>check d</td>
<td class=xl7313617 width=74 style='border-top:none;border-left:none;
width:56pt'>check e</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>check f</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>doesnt matter</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>doesnt
matter</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 1</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 2</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 3</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 4</td>
<td class=xl7213617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 5</td>
<td class=xl7313617 width=74 style='border-top:none;border-left:none;
width:56pt'>output 6</td>
</tr>
<tr class=xl6513617 height=34 style='height:25.5pt'>
<td height=34 class=xl7213617 width=74 style='height:25.5pt;width:56pt'>a</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>0</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a - ffsfdff</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>21</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>30-3000s</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a - ggdg</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>x</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>y</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>z</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>S60 -dddddd</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>bolts</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>something</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>12</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>1000</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>50</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>file name 1</td>
</tr>
<tr class=xl6513617 height=34 style='height:25.5pt'>
<td height=34 class=xl7213617 width=74 style='height:25.5pt;width:56pt'>b</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>1</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>f</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b - frerw</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>31</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>40-4000w</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b - rgfdgd</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>x</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>y</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>z</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>P76 -<span
style='mso-spacerun:yes'> </span>wwww</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>nuts</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>other</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>34</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>3000</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>60</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>file name 2</td>
</tr>
<tr class=xl6513617 height=34 style='height:25.5pt'>
<td height=34 class=xl7213617 width=74 style='height:25.5pt;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>0</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c - dffewf</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>41</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>50-5000q</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c - fgddfg</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>x</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>y</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>z</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>S60 -dddddd</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>screews</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>xxx</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>56</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>5000</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>70</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>file name 3</td>
</tr>
<tr class=xl6513617 height=34 style='height:25.5pt'>
<td height=34 class=xl7213617 width=74 style='height:25.5pt;width:56pt'>d</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>1</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>f</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>d - ytyyu</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>56</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>57-5700t</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>e -tyui</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>x</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>y</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>z</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>N60 -<span
style='mso-spacerun:yes'> </span>sssssssss</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>a</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>b</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>c</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>washers</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>123</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>78</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>7000</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>80</td>
<td class=xl7213617 width=74 style='border-left:none;width:56pt'>file name 4</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6713617 width=74 style='height:15.0pt;width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6613617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6613617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6613617 width=74 style='width:56pt'></td>
<td class=xl6613617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6713617 width=74 style='width:56pt'></td>
<td class=xl6613617 width=74 style='width:56pt'></td>
<td class=xl6513617 width=74 style='width:56pt'> </td>
<td class=xl6513617 width=74 style='border-left:none;width:56pt'> </td>
<td class=xl6513617 width=74 style='border-left:none;width:56pt'> </td>
<td class=xl6513617 width=74 style='border-left:none;width:56pt'> </td>
<td class=xl6513617 width=74 style='border-left:none;width:56pt'> </td>
<td class=xl6513617 width=74 style='border-left:none;width:56pt'> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
<td width=74 style='width:56pt'></td>
</tr>
<![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

table 2

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<link rel=File-List href="example2_files/filelist.xml">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style id="example2_6799_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl156799
{padding:0px;
mso-ignoreadding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl646799
{padding:0px;
mso-ignoreadding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl656799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl666799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl676799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl686799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:0;
text-align:center;
vertical-align:bottom;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl696799
{padding:0px;
mso-ignoreadding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:0;
text-align:center;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl706799
{padding:0px;
mso-ignoreadding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:0;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl716799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:0;
text-align:center;
vertical-align:bottom;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl726799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:11.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl736799
{padding:0px;
mso-ignoreadding;
color:windowtext;
font-size:14.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
-->
</style>
</head>

<body>
<!--[if !excel]>  <![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="example2_6799" align=center xublishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=1106 style='border-collapse:
collapse;table-layout:fixed;width:832pt'>
<col width=102 style='mso-width-source:userset;mso-width-alt:3730;width:77pt'>
<col class=xl646799 width=77 style='mso-width-source:userset;mso-width-alt:
2816;width:58pt'>
<col width=64 style='mso-width-source:userset;mso-width-alt:2340;width:48pt'>
<col width=64 style='width:48pt'>
<col width=102 style='mso-width-source:userset;mso-width-alt:3730;width:77pt'>
<col class=xl156799 width=102 style='mso-width-source:userset;mso-width-alt:
3730;width:77pt'>
<col class=xl156799 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl706799 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl706799 width=64 span=2 style='width:48pt'>
<col class=xl706799 width=73 style='mso-width-source:userset;mso-width-alt:
2669;width:55pt'>
<col class=xl706799 width=64 style='width:48pt'>
<col width=152 style='mso-width-source:userset;mso-width-alt:5558;width:114pt'>
<tr height=50 style='height:37.5pt'>
<td height=50 class=xl736799 width=102 style='height:37.5pt;width:77pt'>doesnt
matter</td>
<td class=xl676799 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl666799 width=64 style='border-left:none;width:48pt'>b</td>
<td class=xl656799 width=64 style='border-left:none;width:48pt'>c</td>
<td class=xl666799 width=102 style='border-left:none;width:77pt'>1</td>
<td class=xl666799 width=102 style='border-left:none;width:77pt'>2</td>
<td class=xl656799 width=89 style='border-left:none;width:67pt'>d</td>
<td class=xl716799 width=89 style='border-left:none;width:67pt'>3</td>
<td class=xl716799 width=64 style='border-left:none;width:48pt'>e</td>
<td class=xl686799 width=64 style='border-left:none;width:48pt'>4</td>
<td class=xl736799 width=73 style='border-left:none;width:55pt'>doesnt matter</td>
<td class=xl686799 width=64 style='border-left:none;width:48pt'>5</td>
<td class=xl676799 width=152 style='border-left:none;width:114pt'>6</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl646799 style='height:15.0pt'>aa</td>
<td class=xl646799>0</td>
<td class=xl646799>CURVED</td>
<td class=xl646799>a</td>
<td class=xl726799 width=102 style='width:77pt'>bolts</td>
<td class=xl726799 width=102 style='border-left:none;width:77pt'>something</td>
<td class=xl646799>43</td>
<td class=xl726799 width=89 style='width:67pt'>12</td>
<td class=xl696799>5000</td>
<td class=xl726799 width=64 style='width:48pt'>1000</td>
<td class=xl696799>43</td>
<td class=xl726799 width=64 style='width:48pt'>50</td>
<td class=xl726799 width=152 style='border-left:none;width:114pt'>file name 1</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl646799 style='height:15.0pt'>bb</td>
<td class=xl646799>1</td>
<td class=xl646799>FLAT</td>
<td class=xl646799>b</td>
<td class=xl726799 width=102 style='width:77pt'>nuts</td>
<td class=xl726799 width=102 style='border-left:none;width:77pt'>other</td>
<td class=xl646799>56</td>
<td class=xl726799 width=89 style='width:67pt'>34</td>
<td class=xl696799>5000</td>
<td class=xl726799 width=64 style='width:48pt'>3000</td>
<td class=xl696799>56</td>
<td class=xl726799 width=64 style='width:48pt'>60</td>
<td class=xl726799 width=152 style='border-left:none;width:114pt'>file name 2</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl646799 style='height:15.0pt'>cc</td>
<td class=xl646799>0</td>
<td class=xl646799>CURVED</td>
<td class=xl646799>c</td>
<td class=xl726799 width=102 style='width:77pt'>screews</td>
<td class=xl726799 width=102 style='border-left:none;width:77pt'>xxx</td>
<td class=xl646799>43</td>
<td class=xl726799 width=89 style='width:67pt'>56</td>
<td class=xl696799>4000</td>
<td class=xl726799 width=64 style='width:48pt'>5000</td>
<td class=xl696799>43</td>
<td class=xl726799 width=64 style='width:48pt'>70</td>
<td class=xl726799 width=152 style='border-left:none;width:114pt'>file name 3</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl646799 style='height:15.0pt'>dd</td>
<td class=xl646799>1</td>
<td class=xl646799>FLAT</td>
<td class=xl646799>d</td>
<td class=xl726799 width=102 style='width:77pt'>washers</td>
<td class=xl726799 width=102 style='border-left:none;width:77pt'>123</td>
<td class=xl646799>56</td>
<td class=xl726799 width=89 style='width:67pt'>78</td>
<td class=xl696799>4000</td>
<td class=xl726799 width=64 style='width:48pt'>7000</td>
<td class=xl696799>56</td>
<td class=xl726799 width=64 style='width:48pt'>80</td>
<td class=xl726799 width=152 style='border-left:none;width:114pt'>file name 4</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=102 style='width:77pt'></td>
<td width=77 style='width:58pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=102 style='width:77pt'></td>
<td width=102 style='width:77pt'></td>
<td width=89 style='width:67pt'></td>
<td width=89 style='width:67pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=73 style='width:55pt'></td>
<td width=64 style='width:48pt'></td>
<td width=152 style='width:114pt'></td>
</tr>
<![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

 

[Peter_SSs]

First thing is - you need to re-consider how you are posting your sample data. If there is another huge post like the last one I will have to remove it as it makes the thread very hard to read. Please post any tables like you did the first one, or better still, using Excel jeanie or MrExcel HTML Make so we can see the row & column labels.

I still ca't see how you obtained results. I have reproduced them below.
I can see the yellow checks pass and therefore why the orange results appear.
I can see the light green checks pass and therefore why the dark green results appear. I can't see why the grey result appears as it does not seem to come from cell M17.
I can see that the light blue checks pass but the dark blue one does not, so why is there a third row of results? And in any case, why does cell T5 not equal cell M21?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	PRODUCT	check a	check b	check c	check d	check e	doesnt	doesnt	doesnt	doesnt	doesnt	doesnt	doesnt	doesnt	output 1	output 2	output 3	output 4	output 5	output 6
2							matter	matter	matter	matter	matter	matter	matter	matter
3	aa	1	c	b - frerw	56	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c	nuts	5568	99	4800	86	file name x
4	aa	1	c	b - frerw	56	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c	nuts	5676	101	4730	84	file name
5	aa	1	c	b - frerw	21	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c	nuts	5568	265	4640	83	file name
6	aa	1	c	b - frerw	28	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c
7	aa	1	c	b - frerw	31	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c
8	aa	1	c	b - frerw	40	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c
9	aa	1	c	b - frerw	43	30-3000s	c - fgddfg	x	y	z	S60-dddddd	a	b	c
10
11
12	doesnt matter	a	b	c	1	2	d	3	e	4	doesnt matter	5	6
13	aa	1	CURVED	b	nuts	5568	56	99	3000	4800	56	86	file name x
14	bb	1	FLAT	a	nuts	5568	56	99	4000	4780	56	85	file name
15	cc	1	FLAT	a	nuts	5568	56	99	4000	4780	56	85	file name
16	dd	1	FLAT	b	nuts	5676	56	101	5000	4730	56	84	file name
17	aa	1	CURVED	b	nuts	5676	56	101	3000	4730	56	84	file name xx
18	bb	1	FLAT	b	nuts	5676	56	101	5000	4680	56	84	file name
19	cc	1	CURVED	c	nuts	5676	56	101	5000	4680	56	84	file name
20	dd	1	FLAT	b	nuts	5568	56	99	4000	4640	56	83	file name
21	aa	1	CURVED	b	nuts	5568	21	265	4000	4640	56	83	file name xxx
22	bb	1	FLAT	c	nuts	5568	56	99	4000	4620	56	83	file name
23	cc	1	FLAT	c	nuts	5568	56	99	4000	4620	56	83	file name
Extract Data

 

[Peter_SSs]

Also note that I will likely not be on the forum much in the next 6 to 8 days so there may be a considerable delay before I am bale to contribute anything further.