Multi point lookup formula (I am stumped on this one)

Blade Hunter

Blade Hunter

Well-known Member
Joined
Mar 13, 2008
Messages
3,147
Hi Guys, I have a small issue, I need to look up some information, I could do it with code but I would love to do it with formulas if possible.

Here is my sample data:

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 165px"><COL style="WIDTH: 74px"><COL style="WIDTH: 82px"><COL style="WIDTH: 43px"><COL style="WIDTH: 42px"><COL style="WIDTH: 78px"><COL style="WIDTH: 62px"><COL style="WIDTH: 64px"><COL style="WIDTH: 51px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Config</TD><TD>Tier / Class</TD><TD>Super Budget</TD><TD>Budget</TD><TD>Mid </TD><TD>Developing</TD><TD>Standard</TD><TD>Premium</TD><TD>Deluxe</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>DA1</TD><TD>Tier 1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">5.29</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">5.87</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">7.64</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">8.81</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">9.99</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">12.34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">15.28</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD> </TD><TD>Tier 2</TD><TD style="TEXT-ALIGN: right">4.7</TD><TD style="TEXT-ALIGN: right">5.29</TD><TD style="TEXT-ALIGN: right">7.05</TD><TD style="TEXT-ALIGN: right">8.23</TD><TD style="TEXT-ALIGN: right">9.4</TD><TD style="TEXT-ALIGN: right">11.17</TD><TD style="TEXT-ALIGN: right">14.11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD> </TD><TD>Tier 3</TD><TD style="TEXT-ALIGN: right">4.11</TD><TD style="TEXT-ALIGN: right">4.7</TD><TD style="TEXT-ALIGN: right">6.46</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.34</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD> </TD><TD>Tier 4</TD><TD style="TEXT-ALIGN: right">3.52</TD><TD style="TEXT-ALIGN: right">4.11</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">11.17</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD> </TD><TD>Tier 5</TD><TD style="TEXT-ALIGN: right">2.93</TD><TD style="TEXT-ALIGN: right">3.52</TD><TD style="TEXT-ALIGN: right">4.11</TD><TD style="TEXT-ALIGN: right">4.7</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">9.99</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>DA2</TD><TD>Tier 1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">9.99</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">11.17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">12.34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #969696">NA</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">15.28</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">17.63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">19.99</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD> </TD><TD>Tier 2</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">11.17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #969696">NA</TD><TD style="TEXT-ALIGN: right">14.11</TD><TD style="TEXT-ALIGN: right">16.46</TD><TD style="TEXT-ALIGN: right">17.63</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD> </TD><TD>Tier 3</TD><TD style="TEXT-ALIGN: right">7.05</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #969696">NA</TD><TD style="TEXT-ALIGN: right">12.93</TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="TEXT-ALIGN: right">15.28</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD> </TD><TD>Tier 4</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">7.05</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #969696">NA</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">14.11</TD><TD style="TEXT-ALIGN: right">14.11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD> </TD><TD>Tier 5</TD><TD style="TEXT-ALIGN: right">4.11</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">6.46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #969696">NA</TD><TD style="TEXT-ALIGN: right">8.23</TD><TD style="TEXT-ALIGN: right">11.75</TD><TD style="TEXT-ALIGN: right">12.93</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>DA3</TD><TD>Tier 1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">9.99</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">13.52</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">17.63</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">21.16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">25.28</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">29.98</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD> </TD><TD>Tier 2</TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">11.17</TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">17.63</TD><TD style="TEXT-ALIGN: right">21.75</TD><TD style="TEXT-ALIGN: right">25.28</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD> </TD><TD>Tier 3</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.93</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">14.69</TD><TD style="TEXT-ALIGN: right">17.63</TD><TD style="TEXT-ALIGN: right">21.16</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD> </TD><TD>Tier 4</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">11.75</TD><TD style="TEXT-ALIGN: right">14.11</TD><TD style="TEXT-ALIGN: right">16.46</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD> </TD><TD>Tier 5</TD><TD style="TEXT-ALIGN: right">4.11</TD><TD style="TEXT-ALIGN: right">5.58</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">8.81</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">11.92</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD>DA4</TD><TD>Tier 1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">14.11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">18.22</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">24.1</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">28.22</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">34.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">39.98</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD> </TD><TD>Tier 2</TD><TD style="TEXT-ALIGN: right">11.75</TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="TEXT-ALIGN: right">20.57</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">24.1</TD><TD style="TEXT-ALIGN: right">28.81</TD><TD style="TEXT-ALIGN: right">34.1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD> </TD><TD>Tier 3</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.34</TD><TD style="TEXT-ALIGN: right">16.46</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">19.99</TD><TD style="TEXT-ALIGN: right">24.1</TD><TD style="TEXT-ALIGN: right">27.63</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD> </TD><TD>Tier 4</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.93</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="TEXT-ALIGN: right">18.81</TD><TD style="TEXT-ALIGN: right">21.75</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD> </TD><TD>Tier 5</TD><TD style="TEXT-ALIGN: right">5.87</TD><TD style="TEXT-ALIGN: right">7.64</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">11.17</TD><TD style="TEXT-ALIGN: right">13.52</TD><TD style="TEXT-ALIGN: right">15.28</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>DA5</TD><TD>Tier 1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">17.63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">22.34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">29.98</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">35.27</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">42.33</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">49.97</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD> </TD><TD>Tier 2</TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="TEXT-ALIGN: right">19.4</TD><TD style="TEXT-ALIGN: right">25.28</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">29.98</TD><TD style="TEXT-ALIGN: right">36.45</TD><TD style="TEXT-ALIGN: right">42.33</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD> </TD><TD>Tier 3</TD><TD style="TEXT-ALIGN: right">12.34</TD><TD style="TEXT-ALIGN: right">15.28</TD><TD style="TEXT-ALIGN: right">21.16</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">24.1</TD><TD style="TEXT-ALIGN: right">29.98</TD><TD style="TEXT-ALIGN: right">35.27</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD> </TD><TD>Tier 4</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.34</TD><TD style="TEXT-ALIGN: right">16.46</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">19.4</TD><TD style="TEXT-ALIGN: right">23.51</TD><TD style="TEXT-ALIGN: right">27.63</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD> </TD><TD>Tier 5</TD><TD style="TEXT-ALIGN: right">7.05</TD><TD style="TEXT-ALIGN: right">9.99</TD><TD style="TEXT-ALIGN: right">12.34</TD><TD style="BACKGROUND-COLOR: #969696"> </TD><TD style="TEXT-ALIGN: right">14.11</TD><TD style="TEXT-ALIGN: right">17.63</TD><TD style="TEXT-ALIGN: right">19.99</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Here are the rules:

I have the config (Example DA2)
I have a price (Example 15.28)
I need to find the Tier and the Class.

Some prices appear in multiple spots. In this case I need to follow these rules:

Stay Standard if possible
Otherwise check one column to the left and right of standard
If still not found check one more column out
and so on and so forth.

In my example I would expect Standard and Tier 1 to be returned

As another example I have DA1 and 4.11 as the price

I would expect Mid Tier 5 to be returned over Budget 4 or Super Budget 3

Hope that makes sense and hope this can be done with formulas, don't worry about posting VBA code as I can do that myself and I don't want to waste anyones time but if it can be done with formulas I would be super happy.

Edit: I can reconfigure the layout or repeat the config headings if needed, this data will be used for this purpose only so I can play around with the layout (initially it came from elsewhere which is the reason for the format)

Cheers

Dan
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
Hi Blade,

Someone else may have a better (simpler) solution, but i think this works.

K L M N O P
<TABLE style="WIDTH: 276pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=368><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; HEIGHT: 25.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=34 width=64>value</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 36pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=48>DA</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64>Lookup Range</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64>Tier Range</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64>OFFSET</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #c5d9f1; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=64>Tier</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20>4.11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>C2:I6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>B2:B6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>Tier 5</TD></TR></TBODY></TABLE>

K2: lookup-value
L2: DA number

Formula in M2
="C"&(2+5*(L2-1))&":I"&(6+5*(L2-1))

Formula in N2
="B"&(2+5*(L2-1))&":B"&(6+5*(L2-1))

Array-Formula in O2 (ugly...)
=IF(ISNUMBER(MATCH(7,SMALL(IF(INDIRECT(M2)=K2,COLUMN(INDIRECT(M2)),""),{1;2;3;4;5;6;7}),0)),7,LOOKUP(IF(MAX(IF(INDIRECT(M2)=K2,COLUMN(INDIRECT(M2)),0))>7,IF(MAX(IF(INDIRECT(M2)=K2,COLUMN(INDIRECT(M2)),0))>8,9,8),6),SMALL(IF(INDIRECT(M2)=K2,COLUMN(INDIRECT(M2)),""),{1;2;3;4;5;6;7})))-2

CRTL+SHIFT+ENTER

Formula in P2
=INDEX(INDIRECT(N2),MATCH(K2,OFFSET(INDIRECT(N2),0,O2),0))

HTH

M.
 
Upvote 0
Hello Dan,

If you can move your Standard column to the end, try;

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Config</td><td style="font-weight: bold;;">Tier / Class</td><td style="font-weight: bold;;">Super Budget</td><td style="font-weight: bold;;">Budget</td><td style="font-weight: bold;;">Mid</td><td style="font-weight: bold;;">Developing</td><td style="font-weight: bold;;">Premium</td><td style="font-weight: bold;;">Deluxe</td><td style="font-weight: bold;;">Standard</td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: center;;">Lookup Config</td><td style="font-weight: bold;text-align: center;;">Lookup Price</td><td style="font-weight: bold;text-align: center;;">Head Name</td><td style="font-weight: bold;text-align: center;;">Tier / Class</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">DA1</td><td style=";">Tier 1</td><td style="text-align: right;background-color: #FFFF00;;">5.29</td><td style="text-align: right;background-color: #FFFF00;;">5.87</td><td style="text-align: right;background-color: #FFFF00;;">7.64</td><td style="text-align: right;background-color: #FFFF00;;">8.81</td><td style="text-align: right;background-color: #FFFF00;;">12.34</td><td style="text-align: right;background-color: #FFFF00;;">15.28</td><td style="text-align: right;background-color: #FFFF00;;">9.99</td><td style="text-align: right;;"></td><td style="text-align: center;;">DA2</td><td style="text-align: center;;">15.28</td><td style=";">Standard</td><td style=";">Tier 1</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style=";">Tier 2</td><td style="text-align: right;;">4.7</td><td style="text-align: right;;">5.29</td><td style="text-align: right;;">7.05</td><td style="text-align: right;;">8.23</td><td style="text-align: right;;">11.17</td><td style="text-align: right;;">14.11</td><td style="text-align: right;;">9.4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style=";">Tier 3</td><td style="text-align: right;;">4.11</td><td style="text-align: right;;">4.7</td><td style="text-align: right;;">6.46</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.34</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: center;;">Lookup Config</td><td style="font-weight: bold;text-align: center;;">Lookup Price</td><td style="font-weight: bold;text-align: center;;">Head Name</td><td style="font-weight: bold;text-align: center;;">Tier / Class</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;"></td><td style=";">Tier 4</td><td style="text-align: right;;">3.52</td><td style="text-align: right;;">4.11</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;">11.17</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;"></td><td style="text-align: center;;">DA1</td><td style="text-align: center;;">4.11</td><td style=";">Mid</td><td style=";">Tier 5</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style=";">Tier 5</td><td style="text-align: right;;">2.93</td><td style="text-align: right;;">3.52</td><td style="text-align: right;;">4.11</td><td style="text-align: right;;">4.7</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">DA2</td><td style=";">Tier 1</td><td style="text-align: right;background-color: #FFFF00;;">9.99</td><td style="text-align: right;background-color: #FFFF00;;">11.17</td><td style="text-align: right;background-color: #FFFF00;;">12.34</td><td style="text-align: right;background-color: #969696;;">NA</td><td style="text-align: right;background-color: #FFFF00;;">17.63</td><td style="text-align: right;background-color: #FFFF00;;">19.99</td><td style="text-align: right;background-color: #FFFF00;;">15.28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Tier 2</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">11.17</td><td style="text-align: right;background-color: #969696;;">NA</td><td style="text-align: right;;">16.46</td><td style="text-align: right;;">17.63</td><td style="text-align: right;;">14.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style=";">Tier 3</td><td style="text-align: right;;">7.05</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;">9.99</td><td style="text-align: right;background-color: #969696;;">NA</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">12.93</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style=";">Tier 4</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">7.05</td><td style="text-align: right;;">8.81</td><td style="text-align: right;background-color: #969696;;">NA</td><td style="text-align: right;;">14.11</td><td style="text-align: right;;">14.11</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;"></td><td style=";">Tier 5</td><td style="text-align: right;;">4.11</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">6.46</td><td style="text-align: right;background-color: #969696;;">NA</td><td style="text-align: right;;">11.75</td><td style="text-align: right;;">12.93</td><td style="text-align: right;;">8.23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">DA3</td><td style=";">Tier 1</td><td style="text-align: right;background-color: #FFFF00;;">9.99</td><td style="text-align: right;background-color: #FFFF00;;">13.52</td><td style="text-align: right;background-color: #FFFF00;;">17.63</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;background-color: #FFFF00;;">25.28</td><td style="text-align: right;background-color: #FFFF00;;">29.98</td><td style="text-align: right;background-color: #FFFF00;;">21.16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style=";">Tier 2</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;">11.17</td><td style="text-align: right;;">15.28</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">21.75</td><td style="text-align: right;;">25.28</td><td style="text-align: right;;">17.63</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;"></td><td style=";">Tier 3</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.93</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">17.63</td><td style="text-align: right;;">21.16</td><td style="text-align: right;;">14.69</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;"></td><td style=";">Tier 4</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">14.11</td><td style="text-align: right;;">16.46</td><td style="text-align: right;;">11.75</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;"></td><td style=";">Tier 5</td><td style="text-align: right;;">4.11</td><td style="text-align: right;;">5.58</td><td style="text-align: right;;">7.64</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">11.92</td><td style="text-align: right;;">8.81</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">DA4</td><td style=";">Tier 1</td><td style="text-align: right;background-color: #FFFF00;;">14.11</td><td style="text-align: right;background-color: #FFFF00;;">18.22</td><td style="text-align: right;background-color: #FFFF00;;">24.1</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;background-color: #FFFF00;;">34.1</td><td style="text-align: right;background-color: #FFFF00;;">39.98</td><td style="text-align: right;background-color: #FFFF00;;">28.22</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;"></td><td style=";">Tier 2</td><td style="text-align: right;;">11.75</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">20.57</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">28.81</td><td style="text-align: right;;">34.1</td><td style="text-align: right;;">24.1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;"></td><td style=";">Tier 3</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.34</td><td style="text-align: right;;">16.46</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">24.1</td><td style="text-align: right;;">27.63</td><td style="text-align: right;;">19.99</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;"></td><td style=";">Tier 4</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.93</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">18.81</td><td style="text-align: right;;">21.75</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;"></td><td style=";">Tier 5</td><td style="text-align: right;;">5.87</td><td style="text-align: right;;">7.64</td><td style="text-align: right;;">9.99</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">13.52</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">11.17</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";">DA5</td><td style=";">Tier 1</td><td style="text-align: right;background-color: #FFFF00;;">17.63</td><td style="text-align: right;background-color: #FFFF00;;">22.34</td><td style="text-align: right;background-color: #FFFF00;;">29.98</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;background-color: #FFFF00;;">42.33</td><td style="text-align: right;background-color: #FFFF00;;">49.97</td><td style="text-align: right;background-color: #FFFF00;;">35.27</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;"></td><td style=";">Tier 2</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">19.4</td><td style="text-align: right;;">25.28</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">36.45</td><td style="text-align: right;;">42.33</td><td style="text-align: right;;">29.98</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;"></td><td style=";">Tier 3</td><td style="text-align: right;;">12.34</td><td style="text-align: right;;">15.28</td><td style="text-align: right;;">21.16</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">29.98</td><td style="text-align: right;;">35.27</td><td style="text-align: right;;">24.1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;"></td><td style=";">Tier 4</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.34</td><td style="text-align: right;;">16.46</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">23.51</td><td style="text-align: right;;">27.63</td><td style="text-align: right;;">19.4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style=";">Tier 5</td><td style="text-align: right;;">7.05</td><td style="text-align: right;;">9.99</td><td style="text-align: right;;">12.34</td><td style="text-align: right;background-color: #969696;;"></td><td style="text-align: right;;">17.63</td><td style="text-align: right;;">19.99</td><td style="text-align: right;;">14.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N2</th><td style="text-align:left">=INDEX(<font color="Blue">B2:B26,MATCH(<font color="Red">L2,INDEX(<font color="Green">C2:I26,0,MATCH(<font color="Purple">M2,C1:I1,0</font>)</font>),0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">N5</th><td style="text-align:left">=INDEX(<font color="Blue">B2:B26,MATCH(<font color="Red">L5,INDEX(<font color="Green">C2:I26,0,MATCH(<font color="Purple">M5,C1:I1,0</font>)</font>),0</font>)</font>)</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M2</th><td style="text-align:left">{=INDEX(<font color="Blue">C1:I1,MAX(<font color="Red">IF(<font color="Green">OFFSET(<font color="Purple">C1,MATCH(<font color="Teal">K2,A:A,0</font>)-1,0,5,7</font>)=L2,COLUMN(<font color="Purple">C2:I6</font>)-COLUMN(<font color="Purple">C2</font>)+1</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M5</th><td style="text-align:left">{=INDEX(<font color="Blue">C1:I1,MAX(<font color="Red">IF(<font color="Green">OFFSET(<font color="Purple">C1,MATCH(<font color="Teal">K5,A:A,0</font>)-1,0,5,7</font>)=L5,COLUMN(<font color="Purple">C2:I6</font>)-COLUMN(<font color="Purple">C2</font>)+1</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Also assume always you will have 5 rows on each DA.

Of course will have better than this from experts.
 
Upvote 0
Hi Guys, Firstly, a big thank you to both of you.

I fear I have done the one thing that annoys me the most when people post on here and not posted enough information.

Marcelo, Love the approach but my data is less structured than the sample I posted (I grabbed the first 25 lines, I should have grabbed more).

Haseeb, Looks brilliant, I will try it now but you noted that you are expecting 5 rows per set, there can be up fifteen (Again, I should have posted more).

Here is the complete list of configs and tiers (I have copied config to repeat on rows now).

Again, please accept my apologies for not giving enough information :(

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 235px"><COL style="WIDTH: 99px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Config</TD><TD>Tier / Class</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Digital Audio Longplay #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Digital Audio Longplay #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Digital Audio Longplay #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Digital Audio Longplay #1</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>Digital Audio Longplay #1</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>Digital Audio Longplay #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD>Digital Audio Longplay #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD>Digital Audio Longplay #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>Digital Audio Longplay #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>Digital Audio Longplay #2</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>Digital Audio Longplay #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Digital Audio Longplay #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>Digital Audio Longplay #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD>Digital Audio Longplay #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD>Digital Audio Longplay #3</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD>Digital Audio Longplay #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD>Digital Audio Longplay #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD>Digital Audio Longplay #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD>Digital Audio Longplay #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD>Digital Audio Longplay #4</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>Digital Audio Longplay #5</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD>Digital Audio Longplay #5</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD>Digital Audio Longplay #5</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>Digital Audio Longplay #5</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD>Digital Audio Longplay #5</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 8</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 9</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 10</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 12</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 13</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD>Digital Combo (multiple media) #1 </TD><TD>Tier 14</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 8</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 9</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 10</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 12</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 13</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 14</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD>Digital Combo (multiple media) #2</TD><TD>Tier 15</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">60</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">61</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">62</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">63</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 8</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">64</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 9</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">65</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 10</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">66</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">67</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 12</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">68</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 13</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">69</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 14</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">70</TD><TD>Digital Combo (multiple media) #3</TD><TD>Tier 15</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">71</TD><TD>Digital Audio Extended Play #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">72</TD><TD>Digital Audio Extended Play #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">73</TD><TD>Digital Audio Extended Play #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">74</TD><TD>Digital Audio Extended Play #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">75</TD><TD>Digital Audio Extended Play #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">76</TD><TD>Digital Audio Extended Play #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">77</TD><TD>Digital Audio Extended Play #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">78</TD><TD>Digital Audio Extended Play #2</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">79</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">80</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">81</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">82</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">83</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">84</TD><TD>Digital Audio Extended Play #3</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">85</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">86</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">87</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">88</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">89</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">90</TD><TD>Digital Audio Extended Play #4</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">91</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">92</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">93</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">94</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">95</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">96</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">97</TD><TD>Digital Audio Extended Play #5</TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">98</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">99</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">100</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">101</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">102</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">103</TD><TD>Digital Audio Extended Play #6</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">104</TD><TD>Digital Audio Extended Play #7</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">105</TD><TD>Digital Audio Extended Play #8</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">106</TD><TD>Digital Audio Extended Play #9</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">107</TD><TD>Digital Audio Extended Play #10</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">108</TD><TD>Digital Audio Extended Play #11</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">109</TD><TD>Digital Audio Extended Play #12</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">110</TD><TD>Digital Audio Bundle #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">111</TD><TD>Digital Audio Bundle #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">112</TD><TD>Digital Audio Bundle #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">113</TD><TD>Digital Audio Bundle #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">114</TD><TD>Digital Audio Bundle #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">115</TD><TD>Digital Audio Bundle #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">116</TD><TD>Digital Audio Bundle #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">117</TD><TD>Digital Audio Bundle #2</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">118</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">119</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">120</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">121</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">122</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">123</TD><TD>Digital Audio Bundle #3</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">124</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">125</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">126</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">127</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">128</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">129</TD><TD>Digital Audio Bundle #4</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">130</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">131</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">132</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">133</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">134</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">135</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">136</TD><TD>Digital Audio Bundle #5</TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">137</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">138</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">139</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">140</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">141</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">142</TD><TD>Digital Audio Bundle #6</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">143</TD><TD>Digital Audio Bundle #7</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">144</TD><TD>Digital Audio Bundle #8</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">145</TD><TD>Digital Audio Bundle #9</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">146</TD><TD>Digital Audio Bundle #10</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">147</TD><TD>Digital Audio Bundle #11</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">148</TD><TD>Digital Audio Bundle #12</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">149</TD><TD>Digital Video Bundle #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">150</TD><TD>Digital Video Bundle #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">151</TD><TD>Digital Video Bundle #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">152</TD><TD>Digital Video Bundle #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">153</TD><TD>Digital Video Bundle #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">154</TD><TD>Digital Video Bundle #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">155</TD><TD>Digital Video Bundle #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">156</TD><TD>Digital Video Bundle #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">157</TD><TD>Digital Video Bundle #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">158</TD><TD>Digital Video Bundle #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">159</TD><TD>Digital Video Bundle #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">160</TD><TD>Digital Video Bundle #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">161</TD><TD>Digital Video Bundle #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">162</TD><TD>Digital Video Bundle #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">163</TD><TD>Digital Video Bundle #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">164</TD><TD>Digital Video Bundle #5</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">165</TD><TD>Digital Video Bundle #5</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">166</TD><TD>Digital Video Bundle #5</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">167</TD><TD>Digital Video Bundle #5</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">168</TD><TD>Digital Video Bundle #6</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">169</TD><TD>Digital Video Bundle #6</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">170</TD><TD>Digital Video Bundle #6</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">171</TD><TD>Digital Video Bundle #6</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">172</TD><TD>Digital Video Bundle #7</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">173</TD><TD>Digital Video Bundle #8</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">174</TD><TD>Digital Video Bundle #9</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">175</TD><TD>Digital Video Bundle #10</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">176</TD><TD>Digital Video Bundle #11</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">177</TD><TD>Digital Video Bundle #12</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">178</TD><TD>Digital Video Extended Play #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">179</TD><TD>Digital Video Extended Play #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">180</TD><TD>Digital Video Extended Play #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">181</TD><TD>Digital Video Extended Play #2</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">182</TD><TD>Digital Video Extended Play #2</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">183</TD><TD>Digital Video Extended Play #2</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">184</TD><TD>Digital Video Extended Play #2</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">185</TD><TD>Digital Video Extended Play #3</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">186</TD><TD>Digital Video Extended Play #3</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">187</TD><TD>Digital Video Extended Play #3</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">188</TD><TD>Digital Video Extended Play #3</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">189</TD><TD>Digital Video Extended Play #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">190</TD><TD>Digital Video Extended Play #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">191</TD><TD>Digital Video Extended Play #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">192</TD><TD>Digital Video Extended Play #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">193</TD><TD>Digital Video Extended Play #5</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">194</TD><TD>Digital Video Extended Play #5</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">195</TD><TD>Digital Video Extended Play #5</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">196</TD><TD>Digital Video Extended Play #5</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">197</TD><TD>Digital Video Extended Play #6</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">198</TD><TD>Digital Video Extended Play #6</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">199</TD><TD>Digital Video Extended Play #6</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">200</TD><TD>Digital Video Extended Play #6</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">201</TD><TD>Digital Video Extended Play #7</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">202</TD><TD>Digital Video Extended Play #8</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">203</TD><TD>Digital Video Extended Play #9</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">204</TD><TD>Digital Video Extended Play #10</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">205</TD><TD>Digital Video Extended Play #11</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">206</TD><TD>Digital Video Extended Play #12</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">207</TD><TD>Digital Audio Track #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">208</TD><TD>Digital Audio Track #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">209</TD><TD>Digital Audio Track #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">210</TD><TD>Digital Video Track #1</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">211</TD><TD>Digital Video Track #1</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">212</TD><TD>Digital Video Track #1</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">213</TD><TD>Digital Combo EP #2 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">214</TD><TD>Digital Combo EP #2 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">215</TD><TD>Digital Combo EP #2 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">216</TD><TD>Digital Combo EP #2 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">217</TD><TD>Digital Combo EP #2 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">218</TD><TD>Digital Combo EP #3 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">219</TD><TD>Digital Combo EP #3 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">220</TD><TD>Digital Combo EP #3 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">221</TD><TD>Digital Combo EP #3 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">222</TD><TD>Digital Combo EP #3 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">223</TD><TD>Digital Combo EP #4 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">224</TD><TD>Digital Combo EP #4 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">225</TD><TD>Digital Combo EP #4 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">226</TD><TD>Digital Combo EP #4 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">227</TD><TD>Digital Combo EP #4 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">228</TD><TD>Digital Combo EP #5 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">229</TD><TD>Digital Combo EP #5 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">230</TD><TD>Digital Combo EP #5 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">231</TD><TD>Digital Combo EP #5 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">232</TD><TD>Digital Combo EP #5 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">233</TD><TD>Digital Combo EP #6 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">234</TD><TD>Digital Combo EP #6 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">235</TD><TD>Digital Combo EP #6 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">236</TD><TD>Digital Combo EP #6 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">237</TD><TD>Digital Combo EP #6 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">238</TD><TD>Digital Combo EP #7 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">239</TD><TD>Digital Combo EP #7 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">240</TD><TD>Digital Combo EP #7 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">241</TD><TD>Digital Combo EP #7 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">242</TD><TD>Digital Combo EP #7 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">243</TD><TD>Digital Combo Bundle #2 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">244</TD><TD>Digital Combo Bundle #2 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">245</TD><TD>Digital Combo Bundle #2 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">246</TD><TD>Digital Combo Bundle #2 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">247</TD><TD>Digital Combo Bundle #2 Full / Standard </TD><TD>Tier 5</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Hit export limit from Excel Genie.

Continues

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 235px"><COL style="WIDTH: 99px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">248</TD><TD>Digital Combo Bundle #3 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">249</TD><TD>Digital Combo Bundle #3 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">250</TD><TD>Digital Combo Bundle #3 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">251</TD><TD>Digital Combo Bundle #3 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">252</TD><TD>Digital Combo Bundle #3 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">253</TD><TD>Digital Combo Bundle #4 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">254</TD><TD>Digital Combo Bundle #4 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">255</TD><TD>Digital Combo Bundle #4 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">256</TD><TD>Digital Combo Bundle #4 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">257</TD><TD>Digital Combo Bundle #4 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">258</TD><TD>Digital Combo Bundle #5 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">259</TD><TD>Digital Combo Bundle #5 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">260</TD><TD>Digital Combo Bundle #5 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">261</TD><TD>Digital Combo Bundle #5 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">262</TD><TD>Digital Combo Bundle #5 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">263</TD><TD>Digital Combo Bundle #6 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">264</TD><TD>Digital Combo Bundle #6 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">265</TD><TD>Digital Combo Bundle #6 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">266</TD><TD>Digital Combo Bundle #6 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">267</TD><TD>Digital Combo Bundle #6 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">268</TD><TD>Digital Combo Bundle #7 Full / Standard </TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">269</TD><TD>Digital Combo Bundle #7 Full / Standard </TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">270</TD><TD>Digital Combo Bundle #7 Full / Standard </TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">271</TD><TD>Digital Combo Bundle #7 Full / Standard </TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">272</TD><TD>Digital Combo Bundle #7 Full / Standard </TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">273</TD><TD>Digital Audio Longplay #6</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">274</TD><TD>Digital Audio Longplay #6</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">275</TD><TD>Digital Audio Longplay #6</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">276</TD><TD>Digital Audio Longplay #6</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">277</TD><TD>Digital Audio Longplay #6</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">278</TD><TD>Digital Audio Longplay #7</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">279</TD><TD>Digital Audio Longplay #7</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">280</TD><TD>Digital Audio Longplay #7</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">281</TD><TD>Digital Audio Longplay #7</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">282</TD><TD>Digital Audio Longplay #7</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">283</TD><TD>Digital Audio Longplay #8</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">284</TD><TD>Digital Audio Longplay #8</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">285</TD><TD>Digital Audio Longplay #8</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">286</TD><TD>Digital Audio Longplay #8</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">287</TD><TD>Digital Audio Longplay #8</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">288</TD><TD>Digital Audio Longplay #9</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">289</TD><TD>Digital Audio Longplay #9</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">290</TD><TD>Digital Audio Longplay #9</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">291</TD><TD>Digital Audio Longplay #9</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">292</TD><TD>Digital Audio Longplay #9</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">293</TD><TD>Digital Audio Longplay #10</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">294</TD><TD>Digital Audio Longplay #10</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">295</TD><TD>Digital Audio Longplay #10</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">296</TD><TD>Digital Audio Longplay #10</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">297</TD><TD>Digital Audio Longplay #10</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">298</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">299</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">300</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">301</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">302</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">303</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 6</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">304</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 7</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">305</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 8</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">306</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 9</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">307</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 10</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">308</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">309</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 12</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">310</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 13</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">311</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 14</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">312</TD><TD>Digital Combo (multiple media) #4</TD><TD>Tier 15</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 
Upvote 0
If your config are repeated try this Array Formula for Head Name,

=INDEX(C1:I1,MAX(IF(OFFSET(C1,MATCH(K2,A:A,0)-1,0,COUNTIF(A:A,K2),7)=L2,COLUMN(C2:INDEX(I:I,COUNTIF(A:A,K2)+ROW(C2)))-COLUMN(C2)+1)))

This Array Formula for Tier / Class

=INDEX(B2:B312,MATCH(1,IF(INDEX(C2:I312,0,MATCH(M2,C1:I1,0))=L2,IF(A2:A312=K2,1)),0))
 
Upvote 0
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
619
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
574
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
660
Micron
M
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
V
  • Question Question
Issue with scraping with VBA
Replies
1
Views
692
John_w
J

Forum statistics

Threads
1,224,550
Messages
6,179,459
Members
452,915
Latest member
hannnahheileen

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