Question: lookup values based on multiple criteria, how?

[kterkuile]

I use Excel 2003. Now I have a data sheet in my workbook like this:
<TABLE style="WIDTH: 414pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=551 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 694" width=19><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>A</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>B</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>C</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=72>D</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=19>E</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=29>F</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=66>G</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=64>H</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=64 height=18 x:num>1</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">Label</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">Inbox</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">Processtep</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">StartStock</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">In</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">Out</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">EndStock</TD><TD class=xl28 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 1pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent">Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>2</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Controleren</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>3</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Corrigeren</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>4</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Eindcontr hp</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>5</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Fiat verw hp</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>6</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Fiat verw sp</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17 x:num>7</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=109>AFL Mut rend hp</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=66 x:num>100</TD><TD class=xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl29 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: silver 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=64 height=18 x:num>8</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 32pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" width=43>SNS</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" width=85>AFL Aflossen</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 82pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" width=109>AFL Verw afl_I</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" align=right width=72 x:num>0</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 14pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" align=right width=19 x:num>0</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 22pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" align=right width=29 x:num>0</TD><TD class=xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 50pt; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" align=right width=66 x:num>0</TD><TD class=xl27 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: gray 1pt solid; BACKGROUND-COLOR: transparent" align=right x:num="40255">18-3-2010</TD></TR></TBODY></TABLE>

And i have one worksheet, a presentation sheet per week in the same workbook like this:

<TABLE style="WIDTH: 567pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=755 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5924" width=162><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 8411" width=230><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 122pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=162>A</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 173pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=230>B</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 80pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=107>C</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=64>D</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=64>E</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=64>F</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ccffcc" rowSpan=3>DISBOX</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent">maandag</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent">dinsdag</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent">woensdag</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent">donderdag</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent">vrijdag</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>2</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40252">15-mrt</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40253">16-mrt</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40254">17-mrt</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40255">18-mrt</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40256">19-mrt</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" align=right height=34 x:num>3</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 173pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" width=230>Ver-
werkt</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" width=107>Ver-
werkt</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" width=64>Ver-
werkt</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" width=64>Ver-
werkt</TD><TD class=xl29 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" width=64>Ver-
werkt</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD class=xl32 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 122pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" width=162>AFL Mut rend hp</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>5</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>6</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>7</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>8</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>9</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>10</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR></TBODY></TABLE>

Now, i would like to copy the value in G7 (100) from my data sheet, to my presentation sheet to E4. This should be based on two criteria in my presentation sheet: the date in row 1 and the 'DISBOX'-value in column A. The criteria from A4 and E1 should return 100, the value that has both criteria in the row on my data sheet and return it to E4, the cell where both my criteria cross.

I've seen the discussions on INDEX and MATCH functions, but they all retrieve data from a matrix and my data isn't organised in that way. I stumbled across this user defined function, but can't figure out how to go about it: http://www.mrexcel.com/forum/showthread.php?p=2318361#post2318361[URL="http://www.mrexcel.com/forum/showthread.php?p=2318361#post2318361"]p=2318361#post2318361[/URL].

Does anyone have a hunch or better (as i've seen many times from you Excel giants)?

Take care,

Karel

 

[dannyh927]

After searching and searching...


How do I write a formula to do the following:



If the values in cell a1 = x, and cell b1 = y, and cell c1 = z; then pull the values from cell d1, cell e1, cell f1, and cell g1 into another tab...



I was thinking vlookup but not sure how to do it with multiple criteria's and multiple values to display...

Help...

 

[Andrew Poulsom]

Welcome to the Board.

Please try to give a more real-life example. Do you want to find the entries in columns A:C? Where are the criteria you want to look for?

 

[dannyh927]

This is what im trying to do...

If Cell C= Blank AND Cell D = 'Source List' AND Cell E = 'Yes' AND Cell F = Internal

then display Cell K, O, P, Q onto another sheet...

The reason I am doing this is because I have a sheet with hundreds of rows but in the end after I sort with my criteria I only get about 20 rows. I want to be able to look at the data in a cleaner manner...


<TABLE style="WIDTH: 768pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1024 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=16 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>A</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>D</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>E</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>G</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>H</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>I</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>J</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>K</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>L</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>M</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>N</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>O</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>P</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Q</TD></TR><TR style="HEIGHT: 63pt" height=84><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 63pt; BACKGROUND-COLOR: #ffff99" width=64 height=84>List ID#</TD><TD class=xl79 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>Duplicate of Another List?</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>Source or Downstream (#)</TD><TD class=xl81 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>Impacted List / Report?</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>List Translator</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>Business Process</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>System Code</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>System Business Rules</TD><TD class=xl85 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>System Hosting</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>List Name(s) (Q2)</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>System (Q5)</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>System Owner (Q6)</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64> Origination (Q7)</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64> List Owner (Q8)</TD><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>List Translator (Q18)</TD><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=64>Description</TD></TR><TR style="HEIGHT: 30pt" height=40><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: transparent" width=64 height=40 x:num>18</TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64> </TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Source List</TD><TD class=xl78 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Yes</TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Internal</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Internal</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Internal</TD><TD class=xl84 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Internal</TD><TD class=xl86 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><S style="VISIBILITY: hidden; mso-ignore: visibility"> </S></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" width=64>AIR</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Excel</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64 x:str="Roger ">Roger </TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Vendor</TD><TD class=xl83 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" width=64>Dr. Mum</TD><TD class=xl83 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" width=64>TBD</TD><TD class=xl83 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" width=64>ABCDEF</TD></TR></TBODY></TABLE>

 

[Andrew Poulsom]

Couldn't you use AutoFilter?

 

[dannyh927]

I have been autofiltering but I would like to have one sheet that is presentable since the main sheet is always being updated with new information.

 

[WidiyaMayang]

Like this?

=INDEX(Sheet1!$G$2:$G$8,SUMPRODUCT(--(Sheet1!$C$2:$C$8=$A4),--(Sheet1!$H$2:$H$8=E$1),ROW(Sheet1!$G$2:$G$8)-1))

Hi Andrew,

i have this excel file, what i want to do is find the comment from a table with multiple criteria
i already use your function, and the result was wrong
this is the function that i use
=INDEX(Sheet2!$ck$5:$ck$92,SUMPRODUCT(--(Sheet1!$a$5:$a$92=$A4),--(Sheet1!$H$5:$H$92=E$1),ROW(Sheet2!$ck$5:$ck$92)-1))

note column "ck" is the comment (string)
column "a" is the criteria 1, it is string
column "h" is the criteria 2, it is number

Please help me,

tx
Mayang

 

[Excelestial]

This sounds like a tasty small project to put together for you. Send me message via private email if you don't get a solution and would like me to construct something for you.

 

[Andrew Poulsom]

Welcome to the Board.

If your data starts at row 5 you need to deduct 4 instead of 1:

=INDEX(Sheet2!$ck$5:$ck$92,SUMPRODUCT(--(Sheet1!$a$5:$a$92=$A4),--(Sheet1!$H$5:$H$92=E$1),ROW(Sheet2!$ck$5:$ck$92)-4))

or:

=INDEX(Sheet2!$ck$5:$ck$92,SUMPRODUCT(--(Sheet1!$a$5:$a$92=$A4),--(Sheet1!$H$5:$H$92=E$1),ROW(Sheet2!$ck$5:$ck$92)-ROW(Sheet2!$ck$4)))

 

[Long Nose]

Hi Andrew,

I saw your formula and tried to apply this to a problem I am working on. However, I have not had success. I would like to return an Alpha text based on multiple criteria.

Formula
=INDEX($AW$2:$AW$48,SUMPRODUCT(--($AX$2:$AX$48=$AX94),--($AY$2:$AY$48=$AY94),--($AZ$2:$AZ$48=$AZ94),--($BA$2:$BA$48=$BA94),--($BB$2:$BB$48=$BB94),--($BC$2:$BC$48=$BC94),--($BD$2:$BD$48=$BD94),--($BE$2:$BE$48=$BE94),--($BF$2:$BF$48=$BF94),--($BG$2:$BG$48=$BG94),--($BH$2:$BH$48=$BH94),--($BI$2:$BI$48=$BI94),--($BJ$2:$BJ$48=$BJ94),--($BK$2:$BK$48=$BK94),ROW($AW$2:$AW$48)-1))

Where column AW contains the text code to return if the conditions ("Y" or blank) in 2:48 match the "Y" or blank in rown 94.

What am I missing?

 

[Long Nose]

I think I see one issue. There are some redundant rows with duplicating data resulting in #REF!, but other times it returns a text code, it is hit or miss on the correct answer.