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

N

nickgreening

New Member
Joined
Sep 29, 2006
Messages
12
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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 x:publishsource="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:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice: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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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-ignore:padding;
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 x:publishsource="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>
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
nickgreening said:
... the items that need to checked that have to be the same are labeled a to f ..
Click to expand...
What does that mean? For example 'check c' in the first row of the top table is "a - ffsfdff". I can't see that anywhere else in your samples so what was it checked against and what is it the same as?

Can you confirm that what you are looking to populate is output 1, output 2 etc?

If so can you clarify how you determine the results from that sample data?
 
Upvote 0
Peter_SSs said:
What does that mean? For example 'check c' in the first row of the top table is "a - ffsfdff". I can't see that anywhere else in your samples so what was it checked against and what is it the same as?

Can you confirm that what you are looking to populate is output 1, output 2 etc?

If so can you clarify how you determine the results from that sample data?
Click to expand...

Hi Peter,

sorry this is not clear.

the two tables, i have labelled the columns a to f, have to contain the same values in both tables, but as you pointed out they are not exactly the same, in table 1, it contains in the column, check c, a - ffsfdff, b - frerw, c - dffewf, d - ytyyu and in table 2 it contains, column c, a, b, c, d.

for example
when the inputs a to f are the same in both tables, the information is taken from table 2 and filled in the outputs in table 1.

thanks for the help

Nick
 
Upvote 0
nickgreening said:
.. columns a to f, have to contain the same values in both tables, ... not exactly the same, ...

for example
when the inputs a to f are the same in both tables, the information is taken from table 2 and filled in the outputs in table 1.
Click to expand...
So, I *think* you may be saying that the columns need to be the same except some columns can be "not exactly the same" but it is still not making sense to me.

Let's look at the first row in table 1, and the first row of data in table 2 since you seem to have brought data from that row into the first row in table 1.
I've summarised my interpretation in the sheet below.
With only 1 exact match, 2 first letter matches and 3 no-matches, how did you decide to bring data from that row into table 1?
What am I missing?

Excel Workbook
ABCD
1Table 1Table 2Comments
2check a00Match
3check bcCURVEDNo match but maybe first letter match is ok?
4check ca - ffsfdffaNo match but maybe first letter (or up to the hyphen) match is ok?
5check d2143No match
6check e30-3000s5000No match
7check fS60 -dddddd??No f mentioned in table 2. What to check against?
Check Tables
 
Upvote 0
Hi Peter

thanks for the help.

Please see below with my comments...

thanks

N


Peter_SSs said:
So, I *think* you may be saying that the columns need to be the same except some columns can be "not exactly the same" but it is still not making sense to me. **** ****

Let's look at the first row in table 1, and the first row of data in table 2 since you seem to have brought data from that row into the first row in table 1.
I've summarised my interpretation in the sheet below.
With only 1 exact match, 2 first letter matches and 3 no-matches, how did you decide to bring data from that row into table 1? **** You are correct there three possibilities. ****
What am I missing?
**** the reason why i'm doing this is because the table 1 is a product order logic combined with product data that is taken from table 2. the second table ****

Excel Workbook
ABCD
1**Table 1Table 2Comments
2check a00Match
3check bcCURVEDNo match but maybe first letter match is ok? **** That's correct ****
4check ca - ffsfdffaNo match but maybe first letter (or up to the hyphen) match is ok? **** Yes that is correct
5check d2143No match
6check e30-3000s5000No match
7check fS60 -dddddd??No f mentioned in table 2. What to check against? **** doesn't matter not needed ****
Check Tables
Click to expand...
 
Last edited:
Upvote 0
nickgreening said:
Just to add, when there is no match (check d & e) the output is not displayed.
Click to expand...
So, with the original samples provided ..

- nothing at all would appear in the top table because no rows have a match in d & e?, or

- only the very last row would appear because it matches check d (and a, b, c but not e)?
 
Upvote 0
Hi Peter,

Please see my answer below...

thanks

Nick

Peter_SSs said:
So, with the original samples provided ..

- nothing at all would appear in the top table because no rows have a match in d & e?, or ****** nothing would appear as they do not match ******

- only the very last row would appear because it matches check d (and a, b, c but not e)?
Click to expand...
 
Upvote 0
OK, so what about providing another small sample of the two tables where some data does match (and shows results) and some does not (and doesn't show results), so we can be sure where we are headed?
 
Upvote 0
Hi Peter,

thanks again.

I have created the first table with the info and the outputs completed. and then data table


<html xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
****** http-equiv=Content-Type content="text/html; charset=windows-1252">
****** name=ProgId content=Excel.Sheet>
****** name=Generator content="Microsoft Excel 14">
<link rel=File-List href="example1_3_files/filelist.xml">
<style id="example1_3_20415_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl6420415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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:nowrap;}
.xl6520415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6620415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6720415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6820415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6920415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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:none;
border-bottom:none;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl7020415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl7120415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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: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;}
.xl7220415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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: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;}
.xl7320415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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: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;}
.xl7420415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7520415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7620415
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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: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;}
-->
</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_3_20415" align=center x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=1860 class=xl6520415
style='border-collapse:collapse;table-layout:fixed;width:1398pt'>
<col class=xl6420415 width=100 style='mso-width-source:userset;mso-width-alt:
3657;width:75pt'>
<col class=xl6420415 width=118 style='mso-width-source:userset;mso-width-alt:
4315;width:89pt'>
<col class=xl6420415 width=92 style='mso-width-source:userset;mso-width-alt:
3364;width:69pt'>
<col class=xl6720415 width=114 style='mso-width-source:userset;mso-width-alt:
4169;width:86pt'>
<col class=xl6420415 width=74 style='mso-width-source:userset;mso-width-alt:
2706;width:56pt'>
<col class=xl6420415 width=122 style='mso-width-source:userset;mso-width-alt:
4461;width:92pt'>
<col class=xl6520415 width=87 style='mso-width-source:userset;mso-width-alt:
3181;width:65pt'>
<col class=xl6820415 width=83 style='mso-width-source:userset;mso-width-alt:
3035;width:62pt'>
<col class=xl6520415 width=98 style='mso-width-source:userset;mso-width-alt:
3584;width:74pt'>
<col class=xl6520415 width=92 style='mso-width-source:userset;mso-width-alt:
3364;width:69pt'>
<col class=xl6420415 width=137 style='mso-width-source:userset;mso-width-alt:
5010;width:103pt'>
<col class=xl6420415 width=77 style='mso-width-source:userset;mso-width-alt:
2816;width:58pt'>
<col class=xl6820415 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl6520415 width=87 style='mso-width-source:userset;mso-width-alt:
3181;width:65pt'>
<col class=xl7420415 width=64 style='mso-width-source:userset;mso-width-alt:
2340;width:48pt'>
<col class=xl7420415 width=60 style='mso-width-source:userset;mso-width-alt:
2194;width:45pt'>
<col class=xl7420415 width=64 span=3 style='width:48pt'>
<col class=xl7420415 width=110 style='mso-width-source:userset;mso-width-alt:
4022;width:83pt'>
<col class=xl6520415 width=64 style='width:48pt'>
<tr height=50 style='height:37.5pt'>
<td height=50 class=xl6920415 width=100 style='height:37.5pt;width:75pt'>PRODUCT</td>
<td class=xl7320415 width=118 style='width:89pt'>check a</td>
<td class=xl7220415 width=92 style='width:69pt'>check b</td>
<td class=xl7020415 width=114 style='border-left:none;width:86pt'>check c</td>
<td class=xl7120415 width=74 style='border-left:none;width:56pt'>check d</td>
<td class=xl7120415 width=122 style='border-left:none;width:92pt'>check e</td>
<td class=xl7020415 width=87 style='border-left:none;width:65pt'>doesnt
matter</td>
<td class=xl7020415 width=83 style='border-left:none;width:62pt'>doesnt
matter</td>
<td class=xl7020415 width=98 style='border-left:none;width:74pt'>doesnt
matter</td>
<td class=xl7020415 width=92 style='border-left:none;width:69pt'>doesnt
matter</td>
<td class=xl7020415 width=137 style='border-left:none;width:103pt'>doesnt
matter</td>
<td class=xl7020415 width=77 style='border-left:none;width:58pt'>doesnt
matter</td>
<td class=xl7020415 width=89 style='border-left:none;width:67pt'>doesnt
matter</td>
<td class=xl7020415 width=87 style='border-left:none;width:65pt'>doesnt
matter</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>output 1</td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'>output 2</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>output 3</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>output 4</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>output 5</td>
<td class=xl7620415 width=110 style='border-left:none;width:83pt'>output 6</td>
<td class=xl6520415 width=64 style='width:48pt'></td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>56</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>nuts</td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'>5568</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>99</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>4800</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>86</td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'>file name x</td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>56</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>nuts</td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'>5676</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>101</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>4730</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>84</td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'>file name
xx</td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>21</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>nuts</td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'>5568</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>265</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>4640</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'>83</td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'>file name
xxx</td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>28</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'> </td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>31</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'> </td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>40</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'> </td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<tr class=xl6620415 height=20 style='height:15.0pt'>
<td height=20 class=xl6620415 width=100 style='height:15.0pt;width:75pt'>aa</td>
<td class=xl6620415 width=118 style='border-left:none;width:89pt'>1</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>c</td>
<td class=xl6620415 width=114 style='border-left:none;width:86pt'>b - frerw</td>
<td class=xl6620415 width=74 style='border-left:none;width:56pt'>43</td>
<td class=xl6620415 width=122 style='border-left:none;width:92pt'>30-3000s</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c - fgddfg</td>
<td class=xl6620415 width=83 style='border-left:none;width:62pt'>x</td>
<td class=xl6620415 width=98 style='border-left:none;width:74pt'>y</td>
<td class=xl6620415 width=92 style='border-left:none;width:69pt'>z</td>
<td class=xl6620415 width=137 style='border-left:none;width:103pt'>S60
-dddddd</td>
<td class=xl6620415 width=77 style='border-left:none;width:58pt'>a</td>
<td class=xl6620415 width=89 style='border-left:none;width:67pt'>b</td>
<td class=xl6620415 width=87 style='border-left:none;width:65pt'>c</td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=60 style='border-left:none;width:45pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=64 style='border-left:none;width:48pt'> </td>
<td class=xl7520415 width=110 style='border-left:none;width:83pt'> </td>
<td class=xl6620415 width=64 style='border-left:none;width:48pt'> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=100 style='width:75pt'></td>
<td width=118 style='width:89pt'></td>
<td width=92 style='width:69pt'></td>
<td width=114 style='width:86pt'></td>
<td width=74 style='width:56pt'></td>
<td width=122 style='width:92pt'></td>
<td width=87 style='width:65pt'></td>
<td width=83 style='width:62pt'></td>
<td width=98 style='width:74pt'></td>
<td width=92 style='width:69pt'></td>
<td width=137 style='width:103pt'></td>
<td width=77 style='width:58pt'></td>
<td width=89 style='width:67pt'></td>
<td width=87 style='width:65pt'></td>
<td width=64 style='width:48pt'></td>
<td width=60 style='width:45pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=110 style='width:83pt'></td>
<td width=64 style='width:48pt'></td>
</tr>
<![endif]>
</table>

</div>


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

</html>


<html xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
****** http-equiv=Content-Type content="text/html; charset=windows-1252">
****** name=ProgId content=Excel.Sheet>
****** name=Generator content="Microsoft Excel 14">
<link rel=File-List href="example2_2_files/filelist.xml">
<style id="example2_2_12093_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl1512093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6412093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6512093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6612093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl6712093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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:1.0pt solid black;
border-right:1.0pt solid black;
border-bottom:1.0pt solid black;
border-left:none;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl6812093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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:1.0pt solid black;
border-right:1.0pt solid black;
border-bottom:1.0pt solid black;
border-left:none;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl6912093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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:1.0pt solid black;
border-right:1.0pt solid black;
border-bottom:1.0pt solid black;
border-left:none;
background:#D9D9D9;
mso-pattern:black none;
white-space:normal;}
.xl7012093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7112093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7212093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7312093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
.xl7412093
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:red;
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;}
-->
</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_2_12093" align=center x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=1044 style='border-collapse:
collapse;table-layout:fixed;width:786pt;border-spacing: 0px;orphans: auto;
widows: auto;-webkit-text-stroke-width: 0px'>
<col width=70 style='mso-width-source:userset;mso-width-alt:2560;width:53pt'>
<col class=xl6412093 width=77 style='mso-width-source:userset;mso-width-alt:
2816;width:58pt'>
<col width=64 span=2 style='width:48pt'>
<col class=xl7112093 width=102 span=2 style='mso-width-source:userset;
mso-width-alt:3730;width:77pt'>
<col class=xl1512093 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl7312093 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl6612093 width=64 style='mso-width-source:userset;mso-width-alt:
2340;width:48pt'>
<col class=xl7312093 width=64 style='width:48pt'>
<col class=xl6612093 width=73 style='mso-width-source:userset;mso-width-alt:
2669;width:55pt'>
<col class=xl7312093 width=64 style='width:48pt'>
<col class=xl7112093 width=122 style='mso-width-source:userset;mso-width-alt:
4461;width:92pt'>
<tr height=36 style='height:27.0pt'>
<td height=36 class=xl6712093 width=70 style='height:27.0pt;width:53pt'>doesnt
matter</td>
<td class=xl6712093 width=77 style='width:58pt;background-position:initial initial;
background-repeat:initial initial'>a</td>
<td class=xl6712093 width=64 style='width:48pt;background-position:initial initial;
background-repeat:initial initial'>b</td>
<td class=xl6812093 width=64 style='width:48pt;background-position:initial initial;
background-repeat:initial initial'>c</td>
<td class=xl6912093 width=102 style='width:77pt;background-position:initial initial;
background-repeat:initial initial'>1</td>
<td class=xl6912093 width=102 style='width:77pt;background-position:initial initial;
background-repeat:initial initial'>2</td>
<td class=xl6812093 width=89 style='width:67pt;background-position:initial initial;
background-repeat:initial initial'>d</td>
<td class=xl6912093 width=89 style='width:67pt;background-position:initial initial;
background-repeat:initial initial'>3</td>
<td class=xl6712093 width=64 style='width:48pt;background-position:initial initial;
background-repeat:initial initial'>e</td>
<td class=xl6912093 width=64 style='width:48pt;background-position:initial initial;
background-repeat:initial initial'>4</td>
<td class=xl6712093 width=73 style='width:55pt'>doesnt matter</td>
<td class=xl6912093 width=64 style='width:48pt;background-position:initial initial;
background-repeat:initial initial'>5</td>
<td class=xl7412093 width=122 style='width:92pt'>6</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>aa</td>
<td class=xl6412093>1</td>
<td class=xl6412093>CURVED</td>
<td class=xl6412093>b</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>3000</td>
<td class=xl7212093>4800</td>
<td class=xl6512093>56</td>
<td class=xl7212093>86</td>
<td class=xl7012093>file name x</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>bb</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>a</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4780</td>
<td class=xl6512093>56</td>
<td class=xl7212093>85</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>cc</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>a</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4780</td>
<td class=xl6512093>56</td>
<td class=xl7212093>85</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>dd</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>b<span style='mso-spacerun:yes'> </span></td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5676</td>
<td class=xl6412093>56</td>
<td class=xl7212093>101</td>
<td class=xl6512093>5000</td>
<td class=xl7212093>4730</td>
<td class=xl6512093>56</td>
<td class=xl7212093>84</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>aa</td>
<td class=xl6412093>1</td>
<td class=xl6412093>CURVED</td>
<td class=xl6412093>b</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5676</td>
<td class=xl6412093>56</td>
<td class=xl7212093>101</td>
<td class=xl6512093>3000</td>
<td class=xl7212093>4730</td>
<td class=xl6512093>56</td>
<td class=xl7212093>84</td>
<td class=xl7012093>file name xx</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>bb</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>b</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5676</td>
<td class=xl6412093>56</td>
<td class=xl7212093>101</td>
<td class=xl6512093>5000</td>
<td class=xl7212093>4680</td>
<td class=xl6512093>56</td>
<td class=xl7212093>84</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>cc</td>
<td class=xl6412093>1</td>
<td class=xl6412093>CURVED</td>
<td class=xl6412093>c</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5676</td>
<td class=xl6412093>56</td>
<td class=xl7212093>101</td>
<td class=xl6512093>5000</td>
<td class=xl7212093>4680</td>
<td class=xl6512093>56</td>
<td class=xl7212093>84</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>dd</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>b</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4640</td>
<td class=xl6512093>56</td>
<td class=xl7212093>83</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>aa</td>
<td class=xl6412093>1</td>
<td class=xl6412093>CURVED</td>
<td class=xl6412093>b</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>21</td>
<td class=xl7212093>265</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4640</td>
<td class=xl6512093>56</td>
<td class=xl7212093>83</td>
<td class=xl7012093>file name xxx</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>bb</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>c<span style='mso-spacerun:yes'> </span></td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4620</td>
<td class=xl6512093>56</td>
<td class=xl7212093>83</td>
<td class=xl7012093>file name</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6412093 style='height:15.0pt'>cc</td>
<td class=xl6412093>1</td>
<td class=xl6412093>FLAT</td>
<td class=xl6412093>c</td>
<td class=xl7012093>nuts</td>
<td class=xl7012093>5568</td>
<td class=xl6412093>56</td>
<td class=xl7212093>99</td>
<td class=xl6512093>4000</td>
<td class=xl7212093>4620</td>
<td class=xl6512093>56</td>
<td class=xl7212093>83</td>
<td class=xl7012093>file name</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=70 style='width:53pt'></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=122 style='width:92pt'></td>
</tr>
<![endif]>
</table>

</div>


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

</html>
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
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
356
esben
E
E
  • Question
Create mails with table - standard header specific row
Replies
1
Views
961
esben
E
D
  • Question
How to output a dynamic range where the height of the range varies
Replies
0
Views
983
dagda13
D

Forum statistics

Threads
1,215,456
Messages
6,124,939
Members
449,197
Latest member
k_bs

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