Complex Lookup Function

S

share_knowledge

Board Regular
Joined
Aug 20, 2004
Messages
120
Is there a lookup function where the user can update the two time frame, MONTH, and my table could populated with two different rates? Please see table below for specific. Thanks for any advices...


<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="Book2_files/filelist.xml">
<link rel=Edit-Time-Data href="Book2_files/editdata.mso">
<link rel=OLE-Object-Data href="Book2_files/oledata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>tonyl</o:Author>
<o:LastAuthor>tonyl</o:LastAuthor>
<o:Created>2008-06-04T00:14:22Z</o:Created>
<o:LastSaved>2008-06-04T00:50:07Z</o:LastSaved>
<o:Company>Qualis Health</o:Company>
<o:Version>11.9999</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
.font9
{color:black;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Tahoma;
mso-generic-font-family:auto;
mso-font-charset:0;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style16
{mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
mso-style-name:Comma;
mso-style-id:3;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
.style20
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal_ID_REVOL;}
td
{mso-style-parent:style0;
padding:0px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl25
{mso-style-parent:style0;
font-size:12.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;}
.xl26
{mso-style-parent:style16;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
border:.5pt solid windowtext;}
.xl27
{mso-style-parent:style16;
mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";}
.xl28
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;}
.xl29
{mso-style-parent:style0;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"0\.0";}
.xl30
{mso-style-parent:style0;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:0;}
.xl31
{mso-style-parent:style0;
color:red;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"\@";
text-align:left;}
.xl32
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"\@";
text-align:left;}
.xl33
{mso-style-parent:style0;
color:white;}
.xl34
{mso-style-parent:style0;
text-align:center;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:.5pt solid windowtext;
background:silver;
mso-pattern:auto none;}
.xl35
{mso-style-parent:style0;
text-align:center;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:none;
background:#69FFFF;
mso-pattern:auto none;}
.xl36
{mso-style-parent:style16;
mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl37
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:none;
border-bottom:none;
border-left:.5pt solid windowtext;
background:silver;
mso-pattern:auto none;}
.xl38
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:none;
background:#69FFFF;
mso-pattern:auto none;}
.xl39
{mso-style-parent:style16;
mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl40
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
background:silver;
mso-pattern:auto none;}
.xl41
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#69FFFF;
mso-pattern:auto none;}
.xl42
{mso-style-parent:style16;
mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl43
{mso-style-parent:style0;
color:black;}
.xl44
{mso-style-parent:style16;
mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)";
text-align:center;}
.xl45
{mso-style-parent:style0;}
.xl46
{mso-style-parent:style0;
text-align:center;
border:.5pt solid windowtext;}
.xl47
{mso-style-parent:style16;
mso-number-format:"_-* \#\,\#\#0_-\;\\-* \#\,\#\#0_-\;_-* \0022-\0022??_-\;_-\@_-";
border:.5pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;
mso-protection:unlocked visible;}
.xl48
{mso-style-parent:style0;
mso-number-format:"\#\,\#\#0\;\\\(\#\,\#\#0\\\)";
border:.5pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;
mso-protection:unlocked visible;}
.xl49
{mso-style-parent:style0;
mso-number-format:"\#\,\#\#0\;\\\(\#\,\#\#0\\\)";
border:.5pt solid windowtext;
background:#69FFFF;
mso-pattern:auto none;
mso-protection:unlocked visible;}
.xl50
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0\;\\\(\#\,\#\#0\\\)";
border:.5pt solid windowtext;}
.xl51
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border:.5pt solid windowtext;}
.xl52
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
border:.5pt solid windowtext;}
.xl53
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"_-* \#\,\#\#0\.00_-\;\\-* \#\,\#\#0\.00_-\;_-* \0022-\0022??_-\;_-\@_-";
border:.5pt solid windowtext;}
.xl54
{mso-style-parent:style0;
color:red;
font-size:14.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border:.5pt solid windowtext;
background:#69FFFF;
mso-pattern:auto none;}
.xl55
{mso-style-parent:style0;
color:red;
font-size:14.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
background:#69FFFF;
mso-pattern:auto none;}
.xl56
{mso-style-parent:style0;
color:blue;
font-size:14.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border:.5pt solid windowtext;
background:white;
mso-pattern:auto none;}
.xl57
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"_-* \#\,\#\#0_-\;\\-* \#\,\#\#0_-\;_-* \0022-\0022??_-\;_-\@_-";
border:.5pt solid windowtext;}
.xl58
{mso-style-parent:style20;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border:.5pt solid windowtext;
white-space:normal;}
.xl59
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;
border:.5pt solid windowtext;
white-space:normal;}
.xl60
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:Fixed;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:none;
border-left:.5pt solid windowtext;
white-space:normal;}
.xl61
{mso-style-parent:style0;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:Fixed;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
white-space:normal;}
.xl62
{mso-style-parent:style20;
font-weight:700;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
background:silver;
mso-pattern:auto none;
white-space:normal;}
-->
</style>
<![if !supportAnnotations]><style id="dynCom" type="text/css"><!-- --></style>

<script language="JavaScript"><!--

function msoCommentShow(com_id,anchor_id) {
if(msoBrowserCheck()) {
c = document.all(com_id);
a = document.all(anchor_id);
if (null != c) {
var cw = c.offsetWidth;
var ch = c.offsetHeight;
var aw = a.offsetWidth;
var ah = a.offsetHeight;
var x = a.offsetLeft;
var y = a.offsetTop;
var el = a;
while (el.tagName != "BODY") {
el = el.offsetParent;
x = x + el.offsetLeft;
y = y + el.offsetTop;
}
var bw = document.body.clientWidth;
var bh = document.body.clientHeight;
var bsl = document.body.scrollLeft;
var bst = document.body.scrollTop;
if (x + cw + ah/2 > bw + bsl && x + aw - ah/2 - cw >= bsl ) {
c.style.left = x + aw - ah / 2 - cw;
}
else {
c.style.left = x + ah/2;
}
if (y + ch + ah/2 > bh + bst && y + ah/2 - ch >= bst ) {
c.style.top = y + ah/2 - ch;
}
else {
c.style.top = y + ah/2;
}
c.style.visibility = "visible";
}
}
}

function msoCommentHide(com_id) {
if(msoBrowserCheck()) {
c = document.all(com_id)
if (null != c) {
c.style.visibility = "hidden";
c.style.left = "-10000";
c.style.top = "-10000";
}
}
}

function msoBrowserCheck() {
ms=navigator.appVersion.indexOf("MSIE");
vers = navigator.appVersion.substring(ms+5, ms+6);
ie4 = (ms>0) && (parseInt(vers) >=4);
return ie4
}

if (msoBrowserCheck()) {
document.styleSheets.dynCom.addRule(".msocomspan1","position:absolute");
document.styleSheets.dynCom.addRule(".msocomspan2","position:absolute");
document.styleSheets.dynCom.addRule(".msocomspan2","left:-1.5ex");
document.styleSheets.dynCom.addRule(".msocomspan2","width:2ex");
document.styleSheets.dynCom.addRule(".msocomspan2","height:0.5em");
document.styleSheets.dynCom.addRule(".msocomanch","font-size:0.5em");
document.styleSheets.dynCom.addRule(".msocomanch","color:red");
document.styleSheets.dynCom.addRule(".msocomhide","display: none");
document.styleSheets.dynCom.addRule(".msocomtxt","visibility: hidden");
document.styleSheets.dynCom.addRule(".msocomtxt","position: absolute");
document.styleSheets.dynCom.addRule(".msocomtxt","top:-10000");
document.styleSheets.dynCom.addRule(".msocomtxt","left:-10000");
document.styleSheets.dynCom.addRule(".msocomtxt","width: 33%");
document.styleSheets.dynCom.addRule(".msocomtxt","background: infobackground");
document.styleSheets.dynCom.addRule(".msocomtxt","color: infotext");
document.styleSheets.dynCom.addRule(".msocomtxt","border-top: 1pt solid threedlightshadow");
document.styleSheets.dynCom.addRule(".msocomtxt","border-right: 2pt solid threedshadow");
document.styleSheets.dynCom.addRule(".msocomtxt","border-bottom: 2pt solid threedshadow");
document.styleSheets.dynCom.addRule(".msocomtxt","border-left: 1pt solid threedlightshadow");
document.styleSheets.dynCom.addRule(".msocomtxt","padding: 3pt 3pt 3pt 3pt");
document.styleSheets.dynCom.addRule(".msocomtxt","z-index: 100");
}

// -->
</script>
<![endif]><!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Zoom>75</x:Zoom>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>31</x:ActiveRow>
<x:ActiveCol>5</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9720</x:WindowHeight>
<x:WindowWidth>17115</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>120</x:WindowTopY>
<x:Calculation>ManualCalculation</x:Calculation>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>

<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1377 style='border-collapse:
collapse;table-layout:fixed;width:1032pt'>
<col width=60 style='mso-width-source:userset;mso-width-alt:2194;width:45pt'>
<col width=94 style='mso-width-source:userset;mso-width-alt:3437;width:71pt'>
<col width=101 style='mso-width-source:userset;mso-width-alt:3693;width:76pt'>
<col width=78 style='mso-width-source:userset;mso-width-alt:2852;width:59pt'>
<col width=65 style='mso-width-source:userset;mso-width-alt:2377;width:49pt'>
<col width=71 span=12 style='mso-width-source:userset;mso-width-alt:2596;
width:53pt'>
<col width=25 style='mso-width-source:userset;mso-width-alt:914;width:19pt'>
<col width=22 style='mso-width-source:userset;mso-width-alt:804;width:17pt'>
<col width=33 style='mso-width-source:userset;mso-width-alt:1206;width:25pt'>
<col width=47 style='mso-width-source:userset;mso-width-alt:1718;width:35pt'>
<tr height=17 style='height:12.75pt'>
<td height=17 width=60 style='height:12.75pt;width:45pt'></td>
<td width=94 style='width:71pt'></td>
<td width=101 style='width:76pt'></td>
<td width=78 style='width:59pt'></td>
<td width=65 style='width:49pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=25 style='width:19pt'></td>
<td width=22 style='width:17pt'></td>
<td width=33 style='width:25pt'></td>
<td class=xl27 width=47 style='width:35pt'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=3 style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=12 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td class=xl27></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl33 style='height:12.75pt'></td>
<td class=xl31 colspan=2 style='mso-ignore:colspan'>User Input Month</td>
<td class=xl32></td>
<td colspan=12 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td class=xl27></td>
</tr>
<tr height=24 style='height:18.0pt'>
<td height=24 style='height:18.0pt'></td>
<td class=xl54 x:num>8</td>
<td class=xl55 x:num x:fmla="=12-B4">4</td>
<td class=xl25></td>
<td colspan=16 style='mso-ignore:colspan'></td>
<td class=xl27></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.15pt'>
<td rowspan=2 height=34 class=xl60 width=60 style='border-bottom:.5pt solid black;
height:25.9pt;width:45pt'>Project Name</td>
<td rowspan=2 class=xl62 width=94 style='border-top:none;width:71pt'
x:fmla="=$T$9 & " - " & VLOOKUP($B$4,$S$9:$T$20,2,FALSE) & " Monthly Projection"">Oct
- May Monthly Projection</td>
<td rowspan=2 class=xl62 width=101 style='border-top:none;width:76pt'
x:fmla="=VLOOKUP(B4+1,$S$9:$T$20,2,FALSE) & " - " & $T$20 & " Monthly Projection"">Jun
- Sep Monthly Projection</td>
<td rowspan=2 class=xl58 width=78 style='width:59pt'>Total</td>
<td colspan=12 class=xl51 style='border-left:none' x:str="'2009">2009<![if !supportAnnotations]><span
class=msocomspan1><span class=msocomspan2 id="_anchor_1"
onmouseover="msoCommentShow('_com_1','_anchor_1')"
onmouseout="msoCommentHide('_com_1')" language=JavaScript><a
class=msocomanch href="#_msocom_1" name="_msoanchor_1">[1]</a></span></span><![endif]></td>
<td rowspan=2 class=xl59 width=71 style='width:53pt'>TOTAL</td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td class=xl27></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl51 style='height:12.75pt;border-top:none;border-left:
none' x:str="'Oct">Oct</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Nov">Nov</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Dec">Dec</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jan">Jan</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Feb">Feb</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Mar">Mar</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Apr">Apr</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'May">May</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jun">Jun</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jul">Jul</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Aug">Aug</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Sep">Sep</td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td class=xl27></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>A</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="10"><span
style='mso-spacerun:yes'>**************** </span>10 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="100"><span
style='mso-spacerun:yes'>**************** </span>100 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="480"
x:fmla="=(B7*B$4)+(C7*C$4)"><span style='mso-spacerun:yes'>******
</span>480.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl50 align=right style='border-top:none;border-left:none' x:num
x:fmla="=SUM(E7:P7)">480</td>
<td colspan=4 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>B</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="20"><span
style='mso-spacerun:yes'>**************** </span>20 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="200"><span
style='mso-spacerun:yes'>**************** </span>200 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="960"
x:fmla="=(B8*B$4)+(C8*C$4)"><span style='mso-spacerun:yes'>******
</span>960.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl50 align=right style='border-top:none;border-left:none' x:num
x:fmla="=SUM(E8:P8)">960</td>
<td colspan=4 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>C</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="30"><span
style='mso-spacerun:yes'>**************** </span>30 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="300"><span
style='mso-spacerun:yes'>**************** </span>300 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="1440"
x:fmla="=(B9*B$4)+(C9*C$4)"><span style='mso-spacerun:yes'>***
</span>1,440.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="1440" x:fmla="=SUM(E9:P9)">1,440</td>
<td></td>
<td class=xl34 x:num>1</td>
<td class=xl35>Oct</td>
<td class=xl36 style='border-left:none' x:num="22.33292290000783"><span
style='mso-spacerun:yes'>*</span>22.33 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>D</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="40"><span
style='mso-spacerun:yes'>**************** </span>40 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="400"><span
style='mso-spacerun:yes'>**************** </span>400 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="1920"
x:fmla="=(B10*B$4)+(C10*C$4)"><span style='mso-spacerun:yes'>***
</span>1,920.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="1920" x:fmla="=SUM(E10:P10)">1,920</td>
<td></td>
<td class=xl37 x:num>2</td>
<td class=xl38>Nov</td>
<td class=xl39 style='border-left:none' x:num="20.833528279005115"><span
style='mso-spacerun:yes'>*</span>20.83 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>E</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="50"><span
style='mso-spacerun:yes'>**************** </span>50 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="500"><span
style='mso-spacerun:yes'>**************** </span>500 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="2400"
x:fmla="=(B11*B$4)+(C11*C$4)"><span style='mso-spacerun:yes'>***
</span>2,400.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="2400" x:fmla="=SUM(E11:P11)">2,400</td>
<td></td>
<td class=xl37 x:num>3</td>
<td class=xl38>Dec</td>
<td class=xl39 style='border-left:none' x:num="22.331729726489606"><span
style='mso-spacerun:yes'>*</span>22.33 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl52 style='height:12.75pt;border-top:none'>TOTAL</td>
<td class=xl53 style='border-top:none;border-left:none' x:num="50"
x:fmla="=SUM(B7:B12)"><span style='mso-spacerun:yes'>************
</span>50.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="50"
x:fmla="=SUM(C7:C12)"><span style='mso-spacerun:yes'>**************
</span>50.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="7200"
x:fmla="=SUM(D7:D12)"><span style='mso-spacerun:yes'>*** </span>7,200.00 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(E7:E12)"><span style='mso-spacerun:yes'>******* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(F7:F12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(G7:G12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(H7:H12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(I7:I12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(J7:J12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(K7:K12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(L7:L12)"><span style='mso-spacerun:yes'>********* </span>150 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(M7:M12)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(N7:N12)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(O7:O12)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(P7:P12)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="7200"
x:fmla="=SUM(Q7:Q12)"><span style='mso-spacerun:yes'>****** </span>7,200 </td>
<td></td>
<td class=xl37 x:num>4</td>
<td class=xl38>Jan</td>
<td class=xl39 style='border-left:none' x:num="21.831471679500329"><span
style='mso-spacerun:yes'>*</span>21.83 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl43 style='height:12.75pt'></td>
<td colspan=17 style='mso-ignore:colspan'></td>
<td class=xl37 x:num>5</td>
<td class=xl38>Feb</td>
<td class=xl39 style='border-left:none' x:num="20.834572653494842"><span
style='mso-spacerun:yes'>*</span>20.83 </td>
</tr>
<tr height=8 style='mso-height-source:userset;height:6.0pt'>
<td height=8 class=xl43 style='height:6.0pt'></td>
<td colspan=17 style='mso-ignore:colspan'></td>
<td class=xl37 x:num>6</td>
<td class=xl38>Mar</td>
<td class=xl39 style='border-left:none' x:num="21.833767634603571"><span
style='mso-spacerun:yes'>*</span>21.83 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl33 style='height:12.75pt'></td>
<td class=xl31 colspan=2 style='mso-ignore:colspan'>User Input Month</td>
<td class=xl32></td>
<td colspan=12 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td></td>
<td class=xl37 x:num>7</td>
<td class=xl38>Apr</td>
<td class=xl39 style='border-left:none' x:num="21.834055498144682"><span
style='mso-spacerun:yes'>*</span>21.83 </td>
</tr>
<tr height=24 style='height:18.0pt'>
<td height=24 style='height:18.0pt'></td>
<td class=xl56 x:num>2</td>
<td class=xl56 style='border-left:none' x:num x:fmla="=12-B16">10</td>
<td class=xl25></td>
<td colspan=14 style='mso-ignore:colspan'></td>
<td class=xl37 x:num>8</td>
<td class=xl38>May</td>
<td class=xl39 style='border-left:none' x:num="21.333855858250701"><span
style='mso-spacerun:yes'>*</span>21.33 </td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.15pt'>
<td rowspan=2 height=34 class=xl60 width=60 style='border-bottom:.5pt solid black;
height:25.9pt;width:45pt'>Project Name</td>
<td rowspan=2 class=xl62 width=94 style='border-top:none;width:71pt'
x:fmla="=$T$9 & " - " & VLOOKUP($B$4,$S$9:$T$20,2,FALSE) & " Monthly Projection"">Oct
- May Monthly Projection</td>
<td rowspan=2 class=xl62 width=101 style='border-top:none;width:76pt'
x:fmla="=VLOOKUP(B16+1,$S$9:$T$20,2,FALSE) & " - " & $T$20 & " Monthly Projection"">Dec
- Sep Monthly Projection</td>
<td rowspan=2 class=xl58 width=78 style='width:59pt'>Total</td>
<td colspan=12 class=xl51 style='border-left:none' x:str="'2009">2009<![if !supportAnnotations]><span
class=msocomspan1><span class=msocomspan2 id="_anchor_2"
onmouseover="msoCommentShow('_com_2','_anchor_2')"
onmouseout="msoCommentHide('_com_2')" language=JavaScript><a
class=msocomanch href="#_msocom_2" name="_msoanchor_2">[2]</a></span></span><![endif]></td>
<td rowspan=2 class=xl59 width=71 style='width:53pt'>TOTAL</td>
<td></td>
<td class=xl37 x:num>9</td>
<td class=xl38>Jun</td>
<td class=xl39 style='border-left:none' x:num="21.83405271685443"><span
style='mso-spacerun:yes'>*</span>21.83 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl51 style='height:12.75pt;border-top:none;border-left:
none' x:str="'Oct">Oct</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Nov">Nov</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Dec">Dec</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jan">Jan</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Feb">Feb</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Mar">Mar</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Apr">Apr</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'May">May</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jun">Jun</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Jul">Jul</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Aug">Aug</td>
<td class=xl51 style='border-top:none;border-left:none' x:str="'Sep">Sep</td>
<td></td>
<td class=xl37 x:num>10</td>
<td class=xl38>Jul</td>
<td class=xl39 style='border-left:none' x:num="22.331835415519194"><span
style='mso-spacerun:yes'>*</span>22.33 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>A</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="10"><span
style='mso-spacerun:yes'>**************** </span>10 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="100"><span
style='mso-spacerun:yes'>**************** </span>100 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="480"
x:fmla="=(B19*B$4)+(C19*C$4)"><span style='mso-spacerun:yes'>******
</span>480.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>10</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>100</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="1020" x:fmla="=SUM(E19:P19)">1,020</td>
<td></td>
<td class=xl37 x:num>11</td>
<td class=xl38>Aug</td>
<td class=xl39 style='border-left:none' x:num="21.33481957532311"><span
style='mso-spacerun:yes'>*</span>21.33 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>B</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="20"><span
style='mso-spacerun:yes'>**************** </span>20 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="200"><span
style='mso-spacerun:yes'>**************** </span>200 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="960"
x:fmla="=(B20*B$4)+(C20*C$4)"><span style='mso-spacerun:yes'>******
</span>960.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>20</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>200</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="2040" x:fmla="=SUM(E20:P20)">2,040</td>
<td></td>
<td class=xl40 x:num>12</td>
<td class=xl41>Sep</td>
<td class=xl42 style='border-left:none' x:num="21.832908215915623"><span
style='mso-spacerun:yes'>*</span>21.83 </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>C</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="30"><span
style='mso-spacerun:yes'>**************** </span>30 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="300"><span
style='mso-spacerun:yes'>**************** </span>300 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="1440"
x:fmla="=(B21*B$4)+(C21*C$4)"><span style='mso-spacerun:yes'>***
</span>1,440.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>30</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>300</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="3060" x:fmla="=SUM(E21:P21)">3,060</td>
<td colspan=4 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>D</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="40"><span
style='mso-spacerun:yes'>**************** </span>40 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="400"><span
style='mso-spacerun:yes'>**************** </span>400 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="1920"
x:fmla="=(B22*B$4)+(C22*C$4)"><span style='mso-spacerun:yes'>***
</span>1,920.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>40</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>400</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="4080" x:fmla="=SUM(E22:P22)">4,080</td>
<td colspan=4 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl46 style='height:12.75pt;border-top:none'>E</td>
<td class=xl47 style='border-top:none;border-left:none' x:num="50"><span
style='mso-spacerun:yes'>**************** </span>50 </td>
<td class=xl47 style='border-top:none;border-left:none' x:num="500"><span
style='mso-spacerun:yes'>**************** </span>500 </td>
<td class=xl26 style='border-top:none;border-left:none' x:num="2400"
x:fmla="=(B23*B$4)+(C23*C$4)"><span style='mso-spacerun:yes'>***
</span>2,400.00 </td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl48 align=right style='border-top:none;border-left:none' x:num>50</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl49 align=right style='border-top:none;border-left:none' x:num>500</td>
<td class=xl50 align=right style='border-top:none;border-left:none'
x:num="5100" x:fmla="=SUM(E23:P23)">5,100</td>
<td colspan=4 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl52 style='height:12.75pt;border-top:none'>TOTAL</td>
<td class=xl53 style='border-top:none;border-left:none' x:num="50"
x:fmla="=SUM(B19:B24)"><span style='mso-spacerun:yes'>************
</span>50.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(C19:C24)"><span style='mso-spacerun:yes'>*********
</span>1,500.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="7200"
x:fmla="=SUM(D19:D24)"><span style='mso-spacerun:yes'>*** </span>7,200.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(E19:E24)"><span style='mso-spacerun:yes'>*** </span>150.00 </td>
<td class=xl53 style='border-top:none;border-left:none' x:num="150"
x:fmla="=SUM(F19:F24)"><span style='mso-spacerun:yes'>**** </span>150.00 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(G19:G24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(H19:H24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(I19:I24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(J19:J24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(K19:K24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(L19:L24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(M19:M24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(N19:N24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(O19:O24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="1500"
x:fmla="=SUM(P19:P24)"><span style='mso-spacerun:yes'>****** </span>1,500 </td>
<td class=xl57 style='border-top:none;border-left:none' x:num="15300"
x:fmla="=SUM(Q19:Q24)"><span style='mso-spacerun:yes'>**** </span>15,300 </td>
<td></td>
<td colspan=3 class=xl44 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl43 style='height:12.75pt'></td>
<td colspan=17 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl44 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl43 style='height:12.75pt'></td>
<td colspan=17 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl44 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl43 style='height:12.75pt'></td>
<td colspan=17 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl44 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl43 height=17 style='height:12.75pt'>
<td height=17 style='height:12.75pt'></td>
<td colspan=17 class=xl43 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl44 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=18 style='height:12.75pt;mso-ignore:colspan'></td>
<td colspan=3 class=xl45 style='mso-ignore:colspan'></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=60 style='width:45pt'></td>
<td width=94 style='width:71pt'></td>
<td width=101 style='width:76pt'></td>
<td width=78 style='width:59pt'></td>
<td width=65 style='width:49pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=71 style='width:53pt'></td>
<td width=25 style='width:19pt'></td>
<td width=22 style='width:17pt'></td>
<td width=33 style='width:25pt'></td>
<td width=47 style='width:35pt'></td>
</tr>
<![endif]>
</table>

<div style='mso-element:comment-list'><![if !supportAnnotations]>

<hr class=msocomhide align=left size=1 width="33%">

<![endif]>

<div style='mso-element:comment'><![if !supportAnnotations]>

<div id="_com_1" class=msocomtxt
onmouseover="msoCommentShow('_com_1','_anchor_1')"
onmouseout="msoCommentHide('_com_1')" language=JavaScript><![endif]>

<div><![if !supportAnnotations]><a class=msocomhide href="#_msoanchor_1"
name="_msocom_1">[1]</a><![endif]><!--[if gte mso 9]><xml>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<v:path gradientshapeok="t" o:connecttype="rect"/>
</v:shapetype><v:shape id="_x0000_s1043" type="#_x0000_t202" style='position:absolute;
margin-left:822pt;margin-top:-320.25pt;width:83.25pt;height:24.75pt;
z-index:1;visibility:hidden' fillcolor="infoBackground [80]" o:insetmode="auto">
<v:fill color2="infoBackground [80]"/>
<v:shadow on="t" color="black" obscured="t"/>
<v:path o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>4</x:Row>
<x:Column>4</x:Column>
<x:Author>danc</x:Author>
</x:ClientData>
</v:shape></xml><![endif]--><![if !vml]><span style='mso-ignore:vglayout'><![endif]>

<div v:shape="_x0000_s1043" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font9">Fiscal Years</font></div>

<![if !vml]></span><![endif]></div>

<![if !supportAnnotations]></div>

<![endif]></div>

<div style='mso-element:comment'><![if !supportAnnotations]>

<div id="_com_2" class=msocomtxt
onmouseover="msoCommentShow('_com_2','_anchor_2')"
onmouseout="msoCommentHide('_com_2')" language=JavaScript><![endif]>

<div><![if !supportAnnotations]><a class=msocomhide href="#_msoanchor_2"
name="_msocom_2">[2]</a><![endif]><!--[if gte mso 9]><xml>
<v:shape id="_x0000_s1085" type="#_x0000_t202" style='position:absolute;
margin-left:842.25pt;margin-top:-158.25pt;width:82.5pt;height:24pt;z-index:2;
visibility:hidden' fillcolor="infoBackground [80]" o:insetmode="auto">
<v:fill color2="infoBackground [80]"/>
<v:shadow on="t" color="black" obscured="t"/>
<v:path o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>16</x:Row>
<x:Column>4</x:Column>
<x:Author>danc</x:Author>
</x:ClientData>
</v:shape></xml><![endif]--><![if !vml]><span style='mso-ignore:vglayout'><![endif]>

<div v:shape="_x0000_s1085" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font9">Fiscal Years</font></div>

<![if !vml]></span><![endif]></div>

<![if !supportAnnotations]></div>

<![endif]></div>

</div>

</body>

</html>
 
Sort by date Sort by votes
I bit tough to read those tables. But were I to hazard a guess, I'd guess you're talking about using an INDEX(...,MATCH(...),MATCH(...)) construct.

You might also play with the Lookup Wizard. I don't have Excel on this machine, but if memory serves, you need to install the Lookup Wizard add-in before it will appear on your menu (I think it's on the TOOLS menu).
 
Upvote 0
Can i please send you the table and perhaps you could provide some advices? I have everything built up in the way i want to present and look up the data in range but i can't post the table via this forum. I really appreciate your help.

Thanks!
 
Upvote 0
Here is the example what i'm trying to do but i don't have a way to put in excel or html format in this forum to show you. Month1 & Month2 are where user allow to change the numbers and the table below will automatically change the rate based on these inputs. Hope this make sense. Thanks for your help!


Month1 Month2 Rate1 Rate2
5 7 10 15

Month # 1 2 3 4 5 6 7 8 9 10 11 12
Month Name Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Rate 10 10 10 10 10 15 15 15 15 15 15 15
 
Upvote 0
Take a look at the HLOOKUP() function. It's the horizontal version of VLOOKUP().
Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-FAMILY: Verdana">Month1</TD><TD>Month2</TD><TD>Rate1</TD><TD>Rate2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-FAMILY: Verdana; TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">15</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-FAMILY: Verdana">Month</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">12</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-FAMILY: Verdana">Month</TD><TD>Oct</TD><TD>Nov</TD><TD>Dec</TD><TD>Jan</TD><TD>Feb</TD><TD>Mar</TD><TD>Apr</TD><TD>May</TD><TD>Jun</TD><TD>Jul</TD><TD>Aug</TD><TD>Sep</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-FAMILY: Verdana">Rate</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C2</TD><TD>=HLOOKUP(A12,$B$4:$M$6,3,FALSE)</TD></TR><TR><TD>D2</TD><TD>=HLOOKUP(B12,$B$4:$M$6,3,FALSE)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Alternatively, you could use INDEX(MATCH(...))
 
Upvote 0
I'm so sorry for the confustion but what i actually wanted is the monthly table below to be populated with the two rates (10, 15) listed above. The only inputs in my sheet is the Month1 & Month 2 in ROW 2. Let said if the user change Month1 to 6, the table below should automatically take RATE1 (10) and put in B6 - G6 (Oct - Mar) & the formula should place RATE2 (15) into column H6 - M6. The inputs are in Month1 and Month2 only. The rest should be automatically filled in with a formula which i'm after. Thanks much!
 
Upvote 0
If all you need is to match just two months worth, then you don't even need a lookup. You can get by with a simple IF() statement. Assuming the same layout above, cell B6 and copied right can be
  • =IF(B4<=$A$2,$C$2,$D$2)
 
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
917
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
699
mumps
mumps
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G

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