find value in a table

JuliaSeib

New Member
Joined
Jul 22, 2010
Messages
2
I need to bring in a value from a table matching the row name and column heading.. For example:
<TABLE style="WIDTH: 653pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=871><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 48pt" span=12 width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; WIDTH: 77pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=21 width=103>Cost Center</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Jan</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Feb</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Mar</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Apr</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>May</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Jun</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Jul</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Aug</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Sep</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Oct</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=64>Nov</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; WIDTH: 48pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 2pt double" class=xl68 width=64>Dec</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>341</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>765</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>160</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>709</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>279</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>937</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>269</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>205</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>895</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>644</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>659</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>64</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>266</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>439</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>94</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>891</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>441</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>150</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>846</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>495</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>224</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>192</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>227</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>466</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>722</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>965</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>442</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>771</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>551</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>833</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>720</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>231</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>740</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>252</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>55</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>294</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>731</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>90</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>791</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>190</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>424</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>761</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>445</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>159</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>396</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>209</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>766</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>812</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>876</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>739</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>737</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>648</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>147</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>128</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>415</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>838</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>132</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>787</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>341</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>822</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>105</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>902</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>201</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>140</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>583</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>478</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>430</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>890</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>702</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>375</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>189</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>72</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>733</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>757</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>991</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>659</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>898</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>761</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>769</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>845</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>804</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>789</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>509</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>177</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>504</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>449</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>749</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>166</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>185</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>279</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 align=right>928</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>429</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>817</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>712</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>201</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>544</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>294</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>185</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>122</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>416</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>986</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>850</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>681</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76 align=right>786</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl78 align=right>118</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=21>10</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>393</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>132</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>584</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>576</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>479</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>928</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>904</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>365</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>225</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>502</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79 align=right>84</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl80 align=right>296</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #000000; BORDER-RIGHT: #000000" class=xl63 height=21></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #000000" class=xl81></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #000000" class=xl82></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #000000" class=xl82></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #000000" class=xl81></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #000000; BORDER-RIGHT: #000000" class=xl63 height=21></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 height=21>Cost Center</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 2pt double" class=xl70 align=right>1</TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=21>Month</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl72>Jan</TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #000000; BORDER-RIGHT: #000000" class=xl63 height=22></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000" class=xl83></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 height=22>Value</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: windowtext 2pt double" class=xl74></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD><TD style="BORDER-BOTTOM: #000000; BORDER-LEFT: #000000; BACKGROUND-COLOR: transparent; BORDER-TOP: #000000; BORDER-RIGHT: #000000"></TD></TR></TBODY></TABLE>

Have the value automically fill in based on the cost center and month from the table above. Does anyone know the formula to do this? Thank you,
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
If:
dates are in B1:M1
Cost Centers are in A2:A11
And Lookup Center is in B14
And Lookup Month is in B15

=Index($B$2:$M$11,Match(B14,$A$2:$A$11,0),Match(B13,$B$1:$M$1,0))

If you google Contextures Index Match you'll get a good review of
these formulas - very good reading (debra dalgleish maintains this site at contextures with excellent articles on lookup formulas and other Excel topics)
 
Upvote 0
JuliaSeib,

Welcome to the MrExcel forum.


Excel Workbook
ABCDEFGHIJKLMNOP
1Cost CenterJanFebMarAprMayJunJulAugSepOctNovDecCost Center1
2134176516070927993726920589564465964MonthJan
3226643994891441150846495224192227466
4372296544277155183372023174025255294Value341
5473190791190424761445159396209766812
6587673973764814712841583813217787341
768221050902201140583478430890702375
87189727337579916598987617698456804
98789509177504449749166185279928429817
109712201544294185122416986850681786118
111039313258457647992890436522550284296
12
Sheet1
 
Upvote 0
Thank you so much! I knew it was a match and vlookup but wasn't sure how to put it together. It worked beautifully. Have a great day!:)
 
Upvote 0

Forum statistics

Threads
1,215,045
Messages
6,122,840
Members
449,096
Latest member
Erald

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