Match two sets of data and display specific data

L

lolly150

Board Regular
Joined
Jan 9, 2010
Messages
91
I have two separate worksheets:

I'm trying to find a formula that looks at Column A on both sheets (each client is allocated a unique number) and if they match enter in column D of the referral sheet the month they were seen but only if it is a 1st contact (appt type on column D of contact sheet)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Referral<o:p></o:p>
<TABLE style="BACKGROUND: white; mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 2.0pt 0cm 2.0pt" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
A<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
B<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
C<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
D<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
1<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1pt inset; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: inset windowtext .75pt">
Referral<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1pt inset; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1pt inset; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-alt: inset windowtext .75pt"></TD><TD style="BORDER-BOTTOM: #f0f0f0 1pt inset; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: inset windowtext .75pt; mso-border-right-alt: solid #F0F0F0 1.5pt"></TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 24pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 24pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
2<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 24pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
ID<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 24pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Referral Date<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 24pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Month / year of referral<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 24pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
Month of first contact<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
3<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
4093833<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
16-Jan-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt"></TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
4<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
4859550<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
05-Mar-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Jan-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
5<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
5393720<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
05-Sep-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Mar-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
Jan<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
6<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
3850482<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
29-Feb-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Sep-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
Mar<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
7<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
4831722<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
02-Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Feb-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
8<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
9441566<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
17-Jan-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 9; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
9<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
3930393<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
22-Feb-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Jan-12<o:p></o:p>​



​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR></TBODY></TABLE>​

Contact
<TABLE style="BACKGROUND: white; mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 2.0pt 0cm 2.0pt" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm">
Contact<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt"></TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt"></TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #3867a6 1.5pt solid; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3867A6 1.5pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt"></TD></TR><TR style="HEIGHT: 35.25pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 35.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
2<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 35.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
ID<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 35.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
contact Date<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 35.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
month / year of contact<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 35.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
Appointment Type<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
3<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
5393720<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
26-Jan-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Jan-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
1ST<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
4<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
3850482<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
05-Mar-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Mar-12<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
1ST<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
5<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
9441566<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
16-Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
F/UP<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
6<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
2229441<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
19-Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
F/UP<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
7<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
3440555<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
29-Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Dec-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #f0f0f0 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #F0F0F0 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
F/UP<o:p></o:p>




​
</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 7; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; BACKGROUND: #cacaca; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm">
8<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #3867a6 1.5pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: solid #3867A6 1.5pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
5393720<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
10-Sep-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #f0f0f0 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #F0F0F0 1.5pt">
Sep-11<o:p></o:p>




​
</TD><TD style="BORDER-BOTTOM: #3867a6 1.5pt solid; BORDER-LEFT: #f0f0f0 1pt inset; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0 1pt inset; BORDER-RIGHT: #3867a6 1.5pt solid; PADDING-TOP: 0cm; mso-border-top-alt: inset windowtext .75pt; mso-border-left-alt: inset windowtext .75pt; mso-border-bottom-alt: solid #3867A6 1.5pt; mso-border-right-alt: solid #3867A6 1.5pt">
1st<o:p></o:p>​



​
</TD></TR></TBODY></TABLE>​

I was given the following by someone on here, which worked great until I opened it at work and discovered it gives a name error because it is 2003.

<TABLE style="mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D3<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A3,contact$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A3,Sheet2!$A$3:$A$8,0)),"mmm yyy"),""),"")<o:p></o:p>


</TD></TR><TR style="HEIGHT: 47.55pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D4<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A4,contact!$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A4,contact!$A$3:$A$8,0)),"mmmm yyy"),""),"")<o:p></o:p>


</TD></TR><TR style="mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D5<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Sheet2!$D$3:$D$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0))="1ST",TEXT(INDEX(Sheet2!$B$3:$B$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0)),"mmm"),""),"")<o:p></o:p>


</TD></TR><TR style="mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR><TR style="mso-yfti-irow: 4; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR></TBODY></TABLE>
Please could someone tell me of a way to do the calculation using Excel 2003
 
Sort by date Sort by votes
Try to replace the formula in D3 on referral with...
Rich (BB code): 
=IF(LOOKUP(REPT("z",255),CHOOSE({1,2},"",
  INDEX(contact!$D$3:$D$8,
    MATCH(A3,contact!$A$3:$A$8,0))))="1ST",
   TEXT(INDEX(contact!$B$3:$B$8,
    MATCH(A3,contact!$A$3:$A$8,0)),"mmm-yy"),"")
 
Upvote 0
Thanks for replying

I pasted your sugestion in to D3 on the referal sheet but it didn't accept it (i.e it just showed as text in the cell)

Not sure what i did wrong!! any idea?
 
Upvote 0
lolly150 said:
Thanks for replying

I pasted your sugestion in to D3 on the referal sheet but it didn't accept it (i.e it just showed as text in the cell)

Not sure what i did wrong!! any idea?
Click to expand...

It looks like your D3 is text formatted...

By the way, posted without board formatting, the formula would look like this:

=IF(LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX(contact!$D$3:$D$8,MATCH(A3,contact!$A$3:$A$8,0))))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(A3,contact!$A$3:$A$8,0)),"mmm-yy"),"")

If you still see the formula itself showing in D3...

Select D3.
Activate Edit | Replace.
Set Find what to: =
Set Replace with to: =
Click the Replace All button.
 
Upvote 0
I'm probably being really thick here but is that VB code you've give me? if so i am a complete novice and dont know how to use it.

All i really need is a formula that will compare columns in two worksheets (column A)and if, on the second sheet the cell entry is "1st" in column D), paste the month of contact for the "1st" into D3 on the first worksheet.

Sorry if im hurting your head.
 
Upvote 0
lolly150 said:
I'm probably being really thick here but is that VB code you've give me? if so i am a complete novice and dont know how to use it.

All i really need is a formula that will compare columns in two worksheets (column A)and if, on the second sheet the cell entry is "1st" in column D), paste the month of contact for the "1st" into D3 on the first worksheet.

Sorry if im hurting your head.
Click to expand...

It is not VBA, just a formula + plus a recipe you can carry out manually in order to evaluate the formula. What is your version of Excel?
 
Upvote 0
<TABLE style="mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>

D3<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"><TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=139><COLGROUP><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5083" width=139><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 104pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=139></TD></TR></TBODY></TABLE>
Hi

Im using 2007 at home but the version i use at work is 2003 and this is the one i need to view the spreadsheet

The following worked perfectly o 2007 but when i opened it at work i got a NAME error




=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A3,contact$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A3,Sheet2!$A$3:$A$8,0)),"mmm yyy"),""),"")<o:p></o:p>
</TD></TR><TR style="HEIGHT: 47.55pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D4<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A4,contact!$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A4,contact!$A$3:$A$8,0)),"mmmm yyy"),""),"")<o:p></o:p>
</TD></TR><TR style="mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D5<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Sheet2!$D$3:$D$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0))="1ST",TEXT(INDEX(Sheet2!$B$3:$B$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0)),"mmm"),""),"")<o:p></o:p>
</TD></TR><TR style="mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR><TR style="mso-yfti-irow: 4; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR></TBODY></TABLE>
 
Upvote 0
lolly150 said:
<TABLE style="mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>

D3<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"><TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=139><COLGROUP><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5083" width=139><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 104pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=139></TD></TR></TBODY></TABLE>
Hi

Im using 2007 at home but the version i use at work is 2003 and this is the one i need to view the spreadsheet

The following worked perfectly o 2007 but when i opened it at work i got a NAME error




=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A3,contact$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A3,Sheet2!$A$3:$A$8,0)),"mmm yyy"),""),"")<o:p></o:p>


</TD></TR><TR style="HEIGHT: 47.55pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D4<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; HEIGHT: 47.55pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Contact!$D$3:$D$8,MATCH(referral!A4,contact!$A$3:$A$8,0))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(referral!A4,contact!$A$3:$A$8,0)),"mmmm yyy"),""),"")<o:p></o:p>


</TD></TR><TR style="mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15>D5<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt">=IFERROR(IF(INDEX(Sheet2!$D$3:$D$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0))="1ST",TEXT(INDEX(Sheet2!$B$3:$B$8,MATCH(Sheet1!A5,Sheet2!$A$3:$A$8,0)),"mmm"),""),"")<o:p></o:p>


</TD></TR><TR style="mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR><TR style="mso-yfti-irow: 4; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; WIDTH: 11.25pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt" width=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 1.5pt"></TD></TR></TBODY></TABLE>
Click to expand...

IFERROR does not exist in Excel 2003. Hence:

=IF(LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX(contact!$D$3:$D$8,MATCH(A3,contact!$A$3:$A$8,0))))="1ST",TEXT(INDEX(contact!$B$3:$B$8,MATCH(A3,contact!$A$3:$A$8,0)),"mmm-yy"),"")

What happens exactly when you enter this formula in D3?
 
Last edited:
Upvote 0
it accepts the formula but once i've copied it down it shows no results:

it should show in colum D3 of the referral sheet against line 7 "sep 2011" as this is when a 1st contact was made - contact sheet column D line 7 ??
 
Upvote 0
lolly150 said:
it accepts the formula but once i've copied it down it shows no results:

it should show in colum D3 of the referral sheet against line 7 "sep 2011" as this is when a 1st contact was made - contact sheet column D line 7 ??
Click to expand...

Let's recap...

<TABLE style="WIDTH: 347pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=462><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2645" width=74><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3612" width=102><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5717" width=161><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4437" width=125><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=19 width=74>contact</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 76pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=102> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 121pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=161> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 94pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=125> </TD></TR><TR style="HEIGHT: 14.4pt; mso-height-source: userset" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=19 width=74>ID</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=102>contact Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=161>month / year of contact</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=125>Appointment Type</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>5393720</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>26-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>1ST</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>3850482</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>5-Mar-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Mar-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>1ST</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>9441566</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>16-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>F/UP</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>2229441</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>19-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>F/UP</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>3440555</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>29-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>F/UP</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=19 width=74>5393720</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 76pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=102>10-Sep-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 121pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=161>1-Sep-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 94pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=125>1st</TD></TR></TBODY></TABLE>

Given A1:D8 on the contact sheet, what would be the results on the referral sheet which follows below:

<TABLE style="WIDTH: 427pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=571><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2816" width=79><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4039" width=114><COL style="WIDTH: 147pt; mso-width-source: userset; mso-width-alt: 6968" width=196><COL style="WIDTH: 136pt; mso-width-source: userset; mso-width-alt: 6456" width=182><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=79>referral</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 85pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=114> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 147pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=196> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 136pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=182> </TD></TR><TR style="HEIGHT: 14.4pt; mso-height-source: userset" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=19 width=79>ID</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=114>Referral Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=196>Month / year of referral</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=182>Month of first contact</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>4093833</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>16-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=196> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>4859550</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>5-Mar-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>5393720</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>5-Sep-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Mar-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>3850482</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>29-Feb-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Sep-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>4831722</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>2-Dec-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Feb-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>9441566</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>17-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Dec-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=182> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 59pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=19 width=79>3930393</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 85pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=114>22-Feb-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 147pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=196>1-Jan-12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; WIDTH: 136pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" id=td_post_3151891 class=xl70 width=182> </TD></TR></TBODY></TABLE>

in D3:D9?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
953
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top