Hello,
Can someone please tell me if it is possible to do a VLOOKUP/MATCH using 3 different values:
<TABLE style="WIDTH: 204pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=272 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20>ABC</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 60pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=80></TD><TD class=xl67 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-RIGHT-COLOR: #ece9d8" width=64>08:00</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-RIGHT-COLOR: #ece9d8" width=64>08:15</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Monday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>25/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Tuesday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>26/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Wednesday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>27/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Thursday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>28/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Friday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>29/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Monday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>2/05/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR></TBODY></TABLE>
I need to Link an seperate woork book, matching ABC with the specific time and date...I did have
=VLOOKUP(C1,'Other Workbook.xlsm'!Table_Array,MATCH("ABC"&B2,'Other Workbook.xlsm'!,ABC_Match,0),FALSE)
But its not working!
This is what the table looks like in the "source":
<TABLE style="WIDTH: 500pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=665 border=0><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340; mso-outline-parent: collapsed" width=64><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><TBODY><TR style="HEIGHT: 10.5pt" height=14><TD class=xl5991 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 52pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 10.5pt; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=69 height=14></TD><TD class=xl5992 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 71pt; BACKGROUND-COLOR: #d7e4bc" width=94></TD><TD class=xl5993 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 90pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=120>Date</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:00 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:15 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:30 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:45 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>8:00 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 47pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=62>8:15 AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5987 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">25/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">26/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">2</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">27/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">24</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">28</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">28/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">21</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">26</TD></TR></TBODY></TABLE>
Obviously I'm an extreme novice at Excel but any help would be appreciated. I know I can make a unique identifier in an additional column but would like to avoid this if possible...
(I posted this previously but was advised without a ? I was unlikely to get assistance)
<!-- / message -->
Can someone please tell me if it is possible to do a VLOOKUP/MATCH using 3 different values:
<TABLE style="WIDTH: 204pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=272 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=64 height=20>ABC</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 60pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" width=80></TD><TD class=xl67 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-RIGHT-COLOR: #ece9d8" width=64>08:00</TD><TD class=xl67 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-RIGHT-COLOR: #ece9d8" width=64>08:15</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Monday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>25/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Tuesday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>26/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Wednesday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>27/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Thursday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>28/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Friday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>29/04/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR><TR style="HEIGHT: 15pt; mso-outline-level: 1" height=20><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" height=20>Monday</TD><TD class=xl68 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>2/05/2011</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=middle>#N/A</TD></TR></TBODY></TABLE>
I need to Link an seperate woork book, matching ABC with the specific time and date...I did have
=VLOOKUP(C1,'Other Workbook.xlsm'!Table_Array,MATCH("ABC"&B2,'Other Workbook.xlsm'!,ABC_Match,0),FALSE)
But its not working!
This is what the table looks like in the "source":
<TABLE style="WIDTH: 500pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=665 border=0><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340; mso-outline-parent: collapsed" width=64><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><TBODY><TR style="HEIGHT: 10.5pt" height=14><TD class=xl5991 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 52pt; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 10.5pt; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=69 height=14></TD><TD class=xl5992 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 71pt; BACKGROUND-COLOR: #d7e4bc" width=94></TD><TD class=xl5993 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 90pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=120>Date</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:00 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:15 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:30 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>7:45 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 48pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=64>8:00 AM</TD><TD class=xl5994 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; WIDTH: 47pt; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: silver; BORDER-RIGHT-COLOR: #ece9d8" width=62>8:15 AM</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5987 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">25/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">26/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">2</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">27/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">24</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">28</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl5985 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #bfbfbf" height=17>ABC</TD><TD class=xl5986 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: #d7e4bc">100</TD><TD class=xl5989 style="BORDER-LEFT-COLOR: windowtext; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">28/04/2011</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-WIDTH: 0.5pt; BORDER-RIGHT-COLOR: #ece9d8">0</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">21</TD><TD class=xl5988 style="FONT-WEIGHT: 400; BORDER-LEFT-WIDTH: 0.5pt; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #fac090; BORDER-BOTTOM-WIDTH: 0.5pt; BORDER-BOTTOM-COLOR: #ece9d8; COLOR: black; BORDER-TOP-COLOR: #ece9d8; FONT-FAMILY: 'Arial Rounded MT Bold'; BORDER-RIGHT-WIDTH: 0.5pt; TEXT-DECORATION: none; BORDER-RIGHT-COLOR: #ece9d8; mso-pattern: black none; text-underline-style: none; text-line-through: none">26</TD></TR></TBODY></TABLE>
Obviously I'm an extreme novice at Excel but any help would be appreciated. I know I can make a unique identifier in an additional column but would like to avoid this if possible...
(I posted this previously but was advised without a ? I was unlikely to get assistance)
<!-- / message -->
