INDEX, MATCH formula help

[ddub25]

I have the formula below in I99.

=SUM(E59*H99)

I want to improve it to look for and realise that E59 is the cell to times by H99.

I want it to find the text in column A that is on the same row as the formula (row 99);
Match it to text in column A in range A56:A67;
Realise that there is a Date match in A59 and so Calculate, E59*H99
If Not, return 0

<table width="903" border="0" cellpadding="0" cellspacing="0"><col style="width: 37pt;" width="49"> <col style="width: 61pt;" width="81"> <col style="width: 58pt;" width="77"> <col style="width: 78pt;" width="104"> <col style="width: 82pt;" width="109"> <col style="width: 86pt;" width="114"> <col style="width: 71pt;" width="95"> <col style="width: 63pt;" width="84"> <col style="width: 68pt;" width="90"> <col style="width: 75pt;" width="100"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 37pt;" width="49" height="20"> </td> <td class="xl67" style="border-left: medium none; width: 61pt;" width="81">A</td> <td class="xl67" style="border-left: medium none; width: 58pt;" width="77">B</td> <td class="xl67" style="border-left: medium none; width: 78pt;" width="104">C</td> <td class="xl67" style="border-left: medium none; width: 82pt;" width="109">D</td> <td class="xl67" style="border-left: medium none; width: 86pt;" width="114">E</td> <td class="xl67" style="border-left: medium none; width: 71pt;" width="95">F</td> <td class="xl67" style="border-left: medium none; width: 63pt;" width="84">G</td> <td class="xl67" style="border-left: medium none; width: 68pt;" width="90">H</td> <td class="xl67" style="border-left: medium none; width: 75pt;" width="100">I</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">56</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Sep-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 416.91 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 230.02 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 230.02 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 362.16 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">17.71%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 40.73 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">57</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Oct-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,894.28 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 753.34 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 753.34 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,564.93 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">15.54%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 117.10 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">58</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Nov-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,382.71 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,001.68 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,001.68 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,204.85 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">19.17%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 383.77 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">59</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Dec-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,127.31 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 3,590.05 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 3,590.05 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,679.26 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 583.38 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">60</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jan-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,152.42 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,090.97 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,087.75 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,103.36 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 176.76 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">61</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Feb-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,770.75 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 3,287.68 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,249.29 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,408.25 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 365.51 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">62</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Mar-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,261.16 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 773.33 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 593.49 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 956.90 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 96.44 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">63</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Apr-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,566.67 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,248.77 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,618.81 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,073.65 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 263.06 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">64</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">May-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,455.26 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,829.41 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,454.32 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,085.10 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 236.33 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">65</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jun-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 2,324.57 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 5,025.41 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 3,982.14 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,788.02 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 647.10 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">66</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jul-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,693.51 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,056.87 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,297.45 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 1,287.86 </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">16.25%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 210.83 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">67</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Aug-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl73" style="border-top: medium none; border-left: medium none;">0.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">#DIV/0!</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ - </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20"> </td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 17,045.55 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 21,887.53 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 18,858.32 </td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> £ 13,514.34 </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl77" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl78" style="border-top: medium none; border-left: medium none;"> £ 3,121.01 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td class="xl79">
</td> <td class="xl79">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20"> </td> <td class="xl67" style="border-left: medium none;">A</td> <td class="xl67" style="border-left: medium none;">B</td> <td class="xl67" style="border-left: medium none;">C</td> <td class="xl67" style="border-left: medium none;">D</td> <td class="xl67" style="border-left: medium none;">E</td> <td class="xl67" style="border-left: medium none;">F</td> <td class="xl67" style="border-left: medium none;">G</td> <td class="xl67" style="border-left: medium none;">H</td> <td class="xl67" style="border-left: medium none;">I</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">91</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">Chris W</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">92</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">93</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">94</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl86" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">95</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">96</td> <td class="xl81" style="border-left: medium none;">Sep-10</td> <td class="xl82" style="border-left: medium none;">Investor</td> <td class="xl83" style="border-left: medium none;"> £ 37.35 </td> <td class="xl83" style="border-left: medium none;">-£ 17.00 </td> <td class="xl84" style="border-left: medium none;">8.96%</td> <td class="xl85" style="border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl76" style="border-left: medium none;"> £ 8.63 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">97</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Oct-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 57.66 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;">-£ 114.50 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">3.04%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 28.25 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">98</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Nov-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 92.26 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 5.27 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">6.67%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 75.06 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">99</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Dec-10</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 141.57 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 138.84 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">6.65%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 134.63 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">100</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jan-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 65.76 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 129.50 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">5.71%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 40.79 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">101</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Feb-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 180.44 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 352.07 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">10.19%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 84.35 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">102</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Mar-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 68.62 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;">-£ 35.45 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">5.44%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 22.26 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">103</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Apr-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 157.36 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 410.47 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">10.04%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 60.71 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">104</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">May-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 168.70 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 7.10 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">11.59%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 54.54 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">105</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jun-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 159.96 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 877.39 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">6.88%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 149.33 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">106</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Jul-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 133.34 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;">-£ 296.77 </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">7.87%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">3.75%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ 48.65 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20">107</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">Aug-11</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Investor</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ - </td> <td class="xl72" style="border-top: medium none; border-left: medium none;">0.00%</td> <td class="xl70" style="border-top: medium none; border-left: medium none;">N/A</td> <td class="xl75" style="border-left: medium none;">5.00%</td> <td class="xl73" style="border-top: medium none; border-left: medium none;">0.00%</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> £ - </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl69" style="height: 15pt; border-top: medium none;" height="20"> </td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl69" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,263.02 </td> <td class="xl71" style="border-top: medium none; border-left: medium none;"> £ 1,456.92 </td> <td class="xl69" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl74" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl77" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl78" style="border-top: medium none; border-left: medium none;" align="center">#VALUE!</td> </tr> </tbody></table>

Can anyone help

Dan

 

[justme1122]

I dont know if this is what your after or not but I'll try for you:

=If(iserror(vlookup(a59,a91:i107,8,1)),0,vlookup(a59,a91:i107,8,1)*e59)

 

[barry houdini]

Try this formula in I99

=IF(COUNTIF(A$56:A$67,A99),VLOOKUP(A99,A$56:E$67,5,0)*H99,0)

 

[ddub25]

Thanks for both of your help. Barry, yours is what I was after, thanks very much. Problem solved.

Dan

 

[ddub25]

I have a similar problem on the same table if it's ok to post here.

The formula below is returning the value in E97 if it finds {"Owner","Investor"} to be present.

=IF(C97=0,0,IF(OR(INDEX($B$32:$B$43,MATCH($A$91,$A$32:$A$43,0))={"Owner","Investor"}),E97,G97*F97))

I would like it to return the value in E33, but I would not want to just replace E97 in the formula with E33.
I want it to find E33 more intelligently.

It should realise that the match with A91 is in A33 and so the value in row 33 column E (E33) should be returned
if {"Owner" OR "Investor"} are present.

Can anyone help

Dan