I want the cell in column F of the roster to show the value in column H of the assignments sheet if the names match and column L of the assignments sheet says Retirement, Separation or Termination. (i.e. Row 4 of the roster (CAPEN SAM, should be showing 5/3/2010)
<font size="2">Worksheet: Roster UsedRange: $A$1:$I$5 Range: $A$1:$I$5</font><br /><br /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2"> </font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">A</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">B</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">C</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">D</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">E</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">F</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">G</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">H</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">I</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">1</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA1_705"></a><font size="2">Name</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB1_705"></a><font size="2">Last 4 SSN</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC1_705"></a><font size="2">PERSID</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD1_705"></a><font size="2">Gender</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE1_705"></a><font size="2">Hire Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF1_705"></a><font size="2">SVC End Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG1_705"></a><font size="2">SVC End Reason</font></td><td width="100px" style="background-color:#ffffff;"><a name="cH1_705"></a><font size="2">Years of Service</font></td><td width="100px" style="background-color:#ffffff;"><a name="cI1_705"></a><font size="2">Current Zone</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA2_705"></a><font size="2">ADAMS BILL</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB2_705"></a><font size="2">3956</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC2_705"></a><font size="2"><a title="=SUBSTITUTE(LEFT($A2,4) & LEFT($B2,4)," ", "")" href="#fC2_705">ADAM3956</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD2_705"></a><font size="2">M</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE2_705"></a><font size="2">4/28/2003</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF2_705"></a><font size="2"><a title="=IF(AND(Assignments!$A:$A=A2,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF2_705">12/1/2009</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG2_705"></a><font size="2"><a title="=IF(AND(Assignments!A:A=A2,Assignments!H:H=F2),Assignments!I:I,"")" href="#fG2_705">Separation</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH2_705"></a><font size="2"><a title="=IF(ISBLANK($E2),"",IF(F2="",(TODAY()-$E2)/365,($F2-$E2)/365))" href="#fH2_705">6.6</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI2_705"></a><font size="2"><a title="=IF(ISBLANK($E2),"",IF($H2<=6,"A",IF($H2<=10,"B",IF($H2<=14,"C",IF($H2<=20,"D",IF($H2>20,"E"))))))" href="#fI2_705">B</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA3_705"></a><font size="2">BROWN JOHN</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB3_705"></a><font size="2">6078</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC3_705"></a><font size="2"><a title="=SUBSTITUTE(LEFT($A3,4) & LEFT($B3,4)," ", "")" href="#fC3_705">BROW6078</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD3_705"></a><font size="2">M</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE3_705"></a><font size="2">4/28/2003</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF3_705"></a><font size="2"><a title="=IF(AND(Assignments!$A:$A=A3,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF3_705"></a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG3_705"></a><font size="2"><a title="=IF(AND(Assignments!A:A=A3,Assignments!H:H=F3),Assignments!I:I,"")" href="#fG3_705">0</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH3_705"></a><font size="2"><a title="=IF(ISBLANK($E3),"",IF(F3="",(TODAY()-$E3)/365,($F3-$E3)/365))" href="#fH3_705">7.29041095890411</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI3_705"></a><font size="2"><a title="=IF(ISBLANK($E3),"",IF($H3<=6,"A",IF($H3<=10,"B",IF($H3<=14,"C",IF($H3<=20,"D",IF($H3>20,"E"))))))" href="#fI3_705">B</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA4_705"></a><font size="2">CAPEN SAM</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB4_705"></a><font size="2">7213</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC4_705"></a><font size="2"><a title="=SUBSTITUTE(LEFT($A4,4) & LEFT($B4,4)," ", "")" href="#fC4_705">CAPE7213</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD4_705"></a><font size="2">M</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE4_705"></a><font size="2">11/10/1982</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF4_705"></a><font size="2"><a title="=IF(AND(Assignments!$A:$A=A4,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF4_705"></a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG4_705"></a><font size="2"><a title="=IF(AND(Assignments!A:A=A4,Assignments!H:H=F4),Assignments!I:I,"")" href="#fG4_705"></a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH4_705"></a><font size="2"><a title="=IF(ISBLANK($E4),"",IF(F4="",(TODAY()-$E4)/365,($F4-$E4)/365))" href="#fH4_705">27.7671232876712</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI4_705"></a><font size="2"><a title="=IF(ISBLANK($E4),"",IF($H4<=6,"A",IF($H4<=10,"B",IF($H4<=14,"C",IF($H4<=20,"D",IF($H4>20,"E"))))))" href="#fI4_705">E</a></font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">5</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA5_705"></a><font size="2">SMITH ADAM</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB5_705"></a><font size="2">6272</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC5_705"></a><font size="2"><a title="=SUBSTITUTE(LEFT($A5,4) & LEFT($B5,4)," ", "")" href="#fC5_705">SMIT6272</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cD5_705"></a><font size="2">M</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE5_705"></a><font size="2">4/2/1993</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF5_705"></a><font size="2"><a title="=IF(AND(Assignments!$A:$A=A5,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")" href="#fF5_705"></a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG5_705"></a><font size="2"><a title="=IF(AND(Assignments!A:A=A5,Assignments!H:H=F5),Assignments!I:I,"")" href="#fG5_705"></a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH5_705"></a><font size="2"><a title="=IF(ISBLANK($E5),"",IF(F5="",(TODAY()-$E5)/365,($F5-$E5)/365))" href="#fH5_705">17.3671232876712</a></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI5_705"></a><font size="2"><a title="=IF(ISBLANK($E5),"",IF($H5<=6,"A",IF($H5<=10,"B",IF($H5<=14,"C",IF($H5<=20,"D",IF($H5>20,"E"))))))" href="#fI5_705">D</a></font></td></table></div><p /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Address</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Value</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">Formula</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC2_705"></a><font size="2"><a href="#cC2_705">C2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">ADAM3956</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=SUBSTITUTE(LEFT($A2,4) & LEFT($B2,4)," ", "")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF2_705"></a><font size="2"><a href="#cF2_705">F2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">12/1/2009</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!$A:$A=A2,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG2_705"></a><font size="2"><a href="#cG2_705">G2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">Separation</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!A:A=A2,Assignments!H:H=F2),Assignments!I:I,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH2_705"></a><font size="2"><a href="#cH2_705">H2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">6.6</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E2),"",IF(F2="",(TODAY()-$E2)/365,($F2-$E2)/365))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI2_705"></a><font size="2"><a href="#cI2_705">I2</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">B</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E2),"",IF($H2<=6,"A",IF($H2<=10,"B",IF($H2<=14,"C",IF($H2<=20,"D",IF($H2>20,"E"))))))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC3_705"></a><font size="2"><a href="#cC3_705">C3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">BROW6078</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=SUBSTITUTE(LEFT($A3,4) & LEFT($B3,4)," ", "")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF3_705"></a><font size="2"><a href="#cF3_705">F3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!$A:$A=A3,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG3_705"></a><font size="2"><a href="#cG3_705">G3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">0</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!A:A=A3,Assignments!H:H=F3),Assignments!I:I,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH3_705"></a><font size="2"><a href="#cH3_705">H3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">7.29041095890411</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E3),"",IF(F3="",(TODAY()-$E3)/365,($F3-$E3)/365))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI3_705"></a><font size="2"><a href="#cI3_705">I3</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">B</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E3),"",IF($H3<=6,"A",IF($H3<=10,"B",IF($H3<=14,"C",IF($H3<=20,"D",IF($H3>20,"E"))))))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC4_705"></a><font size="2"><a href="#cC4_705">C4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">CAPE7213</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=SUBSTITUTE(LEFT($A4,4) & LEFT($B4,4)," ", "")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF4_705"></a><font size="2"><a href="#cF4_705">F4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!$A:$A=A4,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG4_705"></a><font size="2"><a href="#cG4_705">G4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!A:A=A4,Assignments!H:H=F4),Assignments!I:I,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH4_705"></a><font size="2"><a href="#cH4_705">H4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">27.7671232876712</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E4),"",IF(F4="",(TODAY()-$E4)/365,($F4-$E4)/365))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI4_705"></a><font size="2"><a href="#cI4_705">I4</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">E</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E4),"",IF($H4<=6,"A",IF($H4<=10,"B",IF($H4<=14,"C",IF($H4<=20,"D",IF($H4>20,"E"))))))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fC5_705"></a><font size="2"><a href="#cC5_705">C5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">SMIT6272</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=SUBSTITUTE(LEFT($A5,4) & LEFT($B5,4)," ", "")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fF5_705"></a><font size="2"><a href="#cF5_705">F5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!$A:$A=A5,OR(Assignments!$I:$I="Retirement",Assignments!$I:$I="Separation",Assignments!$I:$I="Termination")),Assignments!$H:$H,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fG5_705"></a><font size="2"><a href="#cG5_705">G5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(AND(Assignments!A:A=A5,Assignments!H:H=F5),Assignments!I:I,"")</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fH5_705"></a><font size="2"><a href="#cH5_705">H5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">17.3671232876712</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E5),"",IF(F5="",(TODAY()-$E5)/365,($F5-$E5)/365))</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><a name="fI5_705"></a><font size="2"><a href="#cI5_705">I5</a></font></td><td width="100px" style="background-color:#ffffff;"><font size="2">D</font></td><td width="100px" style="background-color:#ffffff;"><font size="2">=IF(ISBLANK($E5),"",IF($H5<=6,"A",IF($H5<=10,"B",IF($H5<=14,"C",IF($H5<=20,"D",IF($H5>20,"E"))))))</font></td></tr></table></div>
<font size="2">Worksheet: Assignments UsedRange: $A$1:$J$6 Range: $A$1:$J$6</font><br /><br /><div style="border: 1px solid #666666; overflow: auto; width:580px; height: 220px;"><table border="1" cellspacing="2" cellpadding="3"><tr><td width="40px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2"> </font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">A</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">B</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">C</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">D</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">E</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">F</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">G</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">H</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">I</font></td><td width="100px" align="center" valign="top" style="background-color:#eeeeee;"><font size="2">J</font></td></tr><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">1</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA1_705"></a><font size="2">Name</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB1_705"></a><font size="2">PERSID</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC1_705"></a><font size="2">EDA</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD1_705"></a><font size="2">Report Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE1_705"></a><font size="2">PRD</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF1_705"></a><font size="2">EDD</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG1_705"></a><font size="2">TERM LV Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cH1_705"></a><font size="2">Detach Date</font></td><td width="100px" style="background-color:#ffffff;"><a name="cI1_705"></a><font size="2">Detach Reason</font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ1_705"></a><font size="2">Status</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">2</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA2_705"></a><font size="2">ADAMS BILL</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB2_705"></a><font size="2">ADAM3956</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC2_705"></a><font size="2">10/1/2007</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD2_705"></a><font size="2">10/1/2007</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE2_705"></a><font size="2">12/1/2009</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG2_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH2_705"></a><font size="2">12/1/2009</font></td><td width="100px" style="background-color:#ffffff;"><a name="cI2_705"></a><font size="2">Separation</font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ2_705"></a><font size="2">ACTIVE</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">3</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA3_705"></a><font size="2">BROWN JOHN</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB3_705"></a><font size="2">BROW6078</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC3_705"></a><font size="2">9/29/2008</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD3_705"></a><font size="2">9/29/2008</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE3_705"></a><font size="2">8/1/2009</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF3_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG3_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH3_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI3_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ3_705"></a><font size="2">ACTIVE</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">4</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA4_705"></a><font size="2">CAPEN SAM</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB4_705"></a><font size="2">CAPE7213</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC4_705"></a><font size="2">3/6/2007</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD4_705"></a><font size="2">3/6/2007</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE4_705"></a><font size="2">4/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF4_705"></a><font size="2">3/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG4_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH4_705"></a><font size="2">3/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cI4_705"></a><font size="2">Transfer</font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ4_705"></a><font size="2">INACTIVE</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">5</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA5_705"></a><font size="2">CAPEN SAM</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB5_705"></a><font size="2">CAPE7213</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC5_705"></a><font size="2">4/30/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD5_705"></a><font size="2">4/6/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE5_705"></a><font size="2">4/1/2013</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF5_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cG5_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cH5_705"></a><font size="2">5/3/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cI5_705"></a><font size="2">Terminate</font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ5_705"></a><font size="2">ACTIVE</font></td><tr><td width="40px" style="background-color:#eeeeee;"><font size="2">6</font></td><td width="100px" style="background-color:#ffffff;"><a name="cA6_705"></a><font size="2">SMITH ADAM</font></td><td width="100px" style="background-color:#ffffff;"><a name="cB6_705"></a><font size="2">SMIT6272</font></td><td width="100px" style="background-color:#ffffff;"><a name="cC6_705"></a><font size="2">12/31/2008</font></td><td width="100px" style="background-color:#ffffff;"><a name="cD6_705"></a><font size="2">12/1/2008</font></td><td width="100px" style="background-color:#ffffff;"><a name="cE6_705"></a><font size="2">12/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cF6_705"></a><font size="2">9/1/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cG6_705"></a><font size="2">8/4/2010</font></td><td width="100px" style="background-color:#ffffff;"><a name="cH6_705"></a><font size="2"></font></td><td width="100px" style="background-color:#ffffff;"><a name="cI6_705"></a><font size="2">Retirement</font></td><td width="100px" style="background-color:#ffffff;"><a name="cJ6_705"></a><font size="2">ACTIVE</font></td></table></div><p />