I can't set-up your spreadsheet but I think that you will need a lookup table like this - columns A and B constitute the table, column D is the query and column E is the result
Sheet4
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:71px;" /><col style="width:13px;" /><col style="width:116px;" /><col style="width:75px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Days</td><td >Prob</td><td > </td><td >Days Outstanding</td><td >Probability</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td style="text-align:right; ">0.98</td><td > </td><td style="text-align:right; ">5</td><td style="text-align:right; ">0.98</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">17</td><td style="text-align:right; ">0.9</td><td > </td><td style="text-align:right; ">18</td><td style="text-align:right; ">0.9</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">31</td><td style="text-align:right; ">0.85</td><td > </td><td style="text-align:right; ">40</td><td style="text-align:right; ">0.85</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">46</td><td style="text-align:right; ">0.75</td><td > </td><td style="text-align:right; ">60</td><td style="text-align:right; ">0.75</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">61</td><td style="text-align:right; ">0.4</td><td > </td><td style="text-align:right; ">74</td><td style="text-align:right; ">0.4</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">75</td><td >No chance</td><td > </td><td style="text-align:right; ">100</td><td >No chance</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td style="text-align:right; ">3</td><td style="text-align:right; ">0.98</td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td >
Spreadsheet Formulas</td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E2</td><td >=VLOOKUP(D2,$A2:B$2:$B$7,2,TRUE)</td></tr><tr><td >E3</td><td >=VLOOKUP(D3,$A$2:B3:$B$7,2,TRUE)</td></tr><tr><td >E4</td><td >=VLOOKUP(D4,$A$2:B4:$B$7,2,TRUE)</td></tr><tr><td >E5</td><td >=VLOOKUP(D5,$A$2:B5:$B$7,2,TRUE)</td></tr><tr><td >E6</td><td >=VLOOKUP(D6,$A$2:B6:$B$7,2,TRUE)</td></tr><tr><td >E7</td><td >=VLOOKUP(D7,$A$2:B7:$B$7,2,TRUE)</td></tr><tr><td >E8</td><td >=VLOOKUP(D8,$A$2:B8:$B$7,2,TRUE)</td></tr></table></td></tr></table>
Excel tables to the web - Excel Jeanie Html 4