olivia.ruiz82
New Member
- Joined
- Feb 21, 2011
- Messages
- 4
Using Excel 2010, I'm trying to lookup dates, so that I can sort by month.
I would like to lookup the dates on the below table,
<TABLE style="WIDTH: 412pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=548><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 4352" width=102><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 3413" width=80><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 5376" width=126><COL style="WIDTH: 180pt; mso-width-source: userset; mso-width-alt: 10240" width=240><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: silver; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 height=20 width=102>Deposit Date</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 60pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=80>JV or ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 95pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=126>Account Number</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 180pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=240>Name</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #ebf1de; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl133 height=20>7/1/2010</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl134>ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Tahoma; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129>1-5305-0999</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl130>Crown Castle lease - 7/10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl133 height=20>7/2/2010</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl134>ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129>1-5305-0999</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128>AT&T site lease - 7/10</TD></TR></TBODY></TABLE>
then return the Month and Sort Order from a table I created in another sheet that shows:
<TABLE style="WIDTH: 264pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=350><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3840" width=90><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 4138" width=97><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" width=66><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 4138" width=97><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; HEIGHT: 12.75pt; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 height=17 width=90>Is Over</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 73pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 width=97>But Not Over</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 50pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 width=66>Month</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 73pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl130 width=97>Sort Order</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>1/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>1/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Jan</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>2/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>2/28/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Feb</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>3/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>3/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Mar</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>4/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>4/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Apr</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>5/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>5/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>May</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>6/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>6/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Jun</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>7/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Jul</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>8/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>8/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Aug</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>9/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>9/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Sep</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>10/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>10/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Oct</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>11/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>11/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Nov</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>12/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>12/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Dec</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>6</TD></TR></TBODY></TABLE>
I was attempting something like formula: =VLOOKUP([Deposit Date],DateSort,Sort_Order)
I would like to lookup the dates on the below table,
<TABLE style="WIDTH: 412pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=548><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 4352" width=102><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 3413" width=80><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 5376" width=126><COL style="WIDTH: 180pt; mso-width-source: userset; mso-width-alt: 10240" width=240><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: silver; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 height=20 width=102>Deposit Date</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 60pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=80>JV or ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 95pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=126>Account Number</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 180pt; FONT-FAMILY: Calibri; BACKGROUND: silver; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl131 width=240>Name</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Tahoma; BACKGROUND: #ebf1de; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl133 height=20>7/1/2010</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl134>ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Tahoma; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129>1-5305-0999</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl130>Crown Castle lease - 7/10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl133 height=20>7/2/2010</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl134>ARC</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129>1-5305-0999</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Tahoma; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128>AT&T site lease - 7/10</TD></TR></TBODY></TABLE>
then return the Month and Sort Order from a table I created in another sheet that shows:
<TABLE style="WIDTH: 264pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=350><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3840" width=90><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 4138" width=97><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2816" width=66><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 4138" width=97><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; HEIGHT: 12.75pt; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 height=17 width=90>Is Over</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 73pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 width=97>But Not Over</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 50pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: white; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl127 width=66>Month</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 73pt; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #9bbb59; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" class=xl130 width=97>Sort Order</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>1/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>1/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Jan</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>2/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>2/28/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Feb</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>3/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>3/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Mar</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>4/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>4/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Apr</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>5/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>5/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>May</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>6/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>6/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Jun</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>7/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Jul</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>8/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>8/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Aug</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>9/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>9/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Sep</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>10/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>10/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Oct</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 height=17 align=right>11/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl128 align=right>11/30/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl127>Nov</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: Arial; BACKGROUND: #ebf1de; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #EBF1DE none" class=xl129 align=right>5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #c4d79b 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 height=17 align=right>12/1/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl128 align=right>12/31/2011</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: 'MS Sans Serif'; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl127>Dec</TD><TD style="BORDER-BOTTOM: #c4d79b 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #c4d79b 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #c4d79b 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl129 align=right>6</TD></TR></TBODY></TABLE>
I was attempting something like formula: =VLOOKUP([Deposit Date],DateSort,Sort_Order)