Hi,
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana>
Gönderen XL Ver.:</font><font size=1 face=verdana> Office XP / </font><font size=1 color=red face=verdana>
OS Ver.:</font><font size=1 face=verdana> Windows XP </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>
Table</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>APR</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Sales</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Month</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YTD</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product A</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B3;$B$9:$F$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$C$8:$F$8;1;0);$C$8:$F$8;0)+1;0)'>55
(ƒx)</ACRONYM></font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B3;$B$9:$K$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$H$8:$K$8;1;0);$H$8:$K$8;0)+6;0)'>44
(ƒx)</ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product B</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B4;$B$9:$F$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$C$8:$F$8;1;0);$C$8:$F$8;0)+1;0)'>66
(ƒx)</ACRONYM></font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B4;$B$9:$K$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$H$8:$K$8;1;0);$H$8:$K$8;0)+6;0)'>88
(ƒx)</ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product C</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B5;$B$9:$F$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$C$8:$F$8;1;0);$C$8:$F$8;0)+1;0)'>77
(ƒx)</ACRONYM></font></td><td bgcolor=white nowrap=true align=center><font size=1 color=blue face=verdana><ACRONYM title='=DÜŞEYARA(B5;$B$9:$K$11;KAÇINCI(YATAYARA(YAZIM.DÜZENİ($D$1&"-06");$H$8:$K$8;1;0);$H$8:$K$8;0)+6;0)'>122
(ƒx)</ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>
Data</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Month</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Cumulative</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jan-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Feb-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mar-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Apr-06</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jan-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Feb-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mar-06</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Apr-06</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product A</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>55</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>1</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>2</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>44</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product B</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>5</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>6</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>7</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>66</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>2</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>4</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>6</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>88</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>11</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Product C</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>9</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>11</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>77</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>6</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>9</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=blue face=verdana>122</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana>
XLtoHTML v1.1 / ExcelTürkiye - 2006©</font></td></tr></table>
C3:
Code:
=VLOOKUP(B3;$B$9:$F$11;MATCH(HLOOKUP(PROPER($D$1&"-06");$C$8:$F$8;1;0);$C$8:$F$8;0)+1;0)
Fill down to C5
And;
D3:
Code:
=VLOOKUP(B3;$B$9:$K$11;MATCH(HLOOKUP(PROPER($D$1&"-06");$H$8:$K$8;1;0);$H$8:$K$8;0)+6;0)
Fill down to D5
Ok?