[TABLE="width: 2007"]
<tbody>[TR]
[TD]Hello Everyone![/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]I am trying to pull specific data (text and numbers) from multiple worksheets that are all in the same workbook and put it all inside one worksheet tab (like a dashboard). So far I have been unsuccessful. I know that vlookup is basically pulling the first lookup value it see's over and over again.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Here is an example:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]From B1:O9 I have everything I need. Below that is where I am having issues.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]This is the formula I am using:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If the value is returned "0" then I need a "0" if the value is returned blank then I need the value to be "-" which is the reason for this formula.[/TD]
[/TR]
[TR]
[TD]I am open to using VBA, but I am still a newbie and don’t really know where to begin.[/TD]
[/TR]
[TR]
[TD]Thank you for the help![/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The cell that says "Lookup Name" is A2.[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1243"]
<colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 6997;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 2787;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2133;" span="12"> <col width="416" style="width: 312pt; mso-width-source: userset; mso-width-alt: 11832;"> <tbody>[TR]
[TD="class: xl73, width: 246, bgcolor: white"] [/TD]
[TD="class: xl73, width: 98, bgcolor: white"] [/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]March[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]April[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]May[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]June[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]July[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]August[/TD]
[TD="class: xl73, width: 416, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl75, width: 246, bgcolor: #5B9BD5"]Lookup Name[/TD]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl68, width: 416, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl149, bgcolor: white"]K-Barn 115.1[/TD]
[TD="class: xl77, bgcolor: white"]Top[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]-[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]26.4[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]37.3[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]13.2[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]14.1[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]-[/TD]
[TD="class: xl79, bgcolor: white"]Bring to next boL[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments [/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Bottom[/TD]
[TD="class: xl80, bgcolor: transparent"]-[/TD]
[TD="class: xl81, bgcolor: transparent"]-[/TD]
[TD="class: xl80"]88.05[/TD]
[TD="class: xl81"]2.535[/TD]
[TD="class: xl80"]95.34[/TD]
[TD="class: xl81"]2.06[/TD]
[TD="class: xl80"]137.8[/TD]
[TD="class: xl81"]2.965[/TD]
[TD="class: xl80"]110.7[/TD]
[TD="class: xl81"]3.074[/TD]
[TD="class: xl80, bgcolor: transparent"]12[/TD]
[TD="class: xl81"]141[/TD]
[TD="class: xl82, bgcolor: white"]out of range-reduce[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Bottom[/TD]
[TD="class: xl71, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"]-[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]0[/TD]
[TD="class: xl72, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl82, bgcolor: white"]-[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]February[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]March[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]April[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]May[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]June[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]July[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Top[/TD]
[TD="class: xl83, bgcolor: transparent"]1.00[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl84, bgcolor: transparent"]0.69[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl85, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"]0.14[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl84, bgcolor: transparent"]0.36[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl82, bgcolor: white"]Talked about last year[/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 98, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl89, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[TD="class: xl146, bgcolor: #5B9BD5, colspan: 12"]Action Items[/TD]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: #5B9BD5, colspan: 2"]Date Submitted[/TD]
[TD="class: xl91, bgcolor: #5B9BD5"]Follow up[/TD]
[/TR]
[TR]
[TD="class: xl148, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl92, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl140, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl93, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl140, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl93, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl118, bgcolor: #5B9BD5, colspan: 15"]Con Report[/TD]
[/TR]
[TR]
[TD="class: xl95, width: 246, bgcolor: #5B9BD5"]Name[/TD]
[TD="class: xl96, width: 98, bgcolor: #5B9BD5"]Type[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]O, W, TF[/TD]
[TD="class: xl95, width: 75, bgcolor: #5B9BD5"]Run[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Target/day[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Actual/day[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Chem/Variance %[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Monthly Cost[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Cost[/TD]
[TD="class: xl97, width: 416, bgcolor: #5B9BD5"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl102, width: 246, bgcolor: yellow"]Totals[/TD]
[TD="class: xl103, width: 98, bgcolor: yellow"] [/TD]
[TD="class: xl104, bgcolor: yellow"] [/TD]
[TD="class: xl105, width: 75, bgcolor: yellow"] [/TD]
[TD="class: xl134, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl134, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl136, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl138, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl138, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl106, width: 416, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl87, width: 246, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 98, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl108, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl109, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl118, bgcolor: #5B9BD5, colspan: 15"] Treat Report[/TD]
[/TR]
[TR]
[TD="class: xl95, width: 246, bgcolor: #5B9BD5"]Name[/TD]
[TD="class: xl95, width: 98, bgcolor: #5B9BD5"]Target[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"] gal/Stop[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Actual[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]Frequency[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]Vol[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Variance %[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Cost[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]$/BOE[/TD]
[TD="class: xl97, width: 416, bgcolor: #5B9BD5"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl103, width: 246, bgcolor: yellow"]Totals[/TD]
[TD="class: xl115, width: 98, bgcolor: yellow"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl103, width: 75, bgcolor: yellow"] [/TD]
[TD="class: xl116, bgcolor: yellow"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl117, width: 416, bgcolor: yellow"] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Hello Everyone![/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]I am trying to pull specific data (text and numbers) from multiple worksheets that are all in the same workbook and put it all inside one worksheet tab (like a dashboard). So far I have been unsuccessful. I know that vlookup is basically pulling the first lookup value it see's over and over again.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Here is an example:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]From B1:O9 I have everything I need. Below that is where I am having issues.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]This is the formula I am using:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If the value is returned "0" then I need a "0" if the value is returned blank then I need the value to be "-" which is the reason for this formula.[/TD]
[/TR]
[TR]
[TD]I am open to using VBA, but I am still a newbie and don’t really know where to begin.[/TD]
[/TR]
[TR]
[TD]Thank you for the help![/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The cell that says "Lookup Name" is A2.[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1243"]
<colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 6997;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 2787;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2133;" span="12"> <col width="416" style="width: 312pt; mso-width-source: userset; mso-width-alt: 11832;"> <tbody>[TR]
[TD="class: xl73, width: 246, bgcolor: white"] [/TD]
[TD="class: xl73, width: 98, bgcolor: white"] [/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]March[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]April[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]May[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]June[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]July[/TD]
[TD="class: xl144, width: 150, bgcolor: #5B9BD5, colspan: 2"]August[/TD]
[TD="class: xl73, width: 416, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl75, width: 246, bgcolor: #5B9BD5"]Lookup Name[/TD]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]AX[/TD]
[TD="class: xl67, bgcolor: #F4B084"]PX[/TD]
[TD="class: xl68, width: 416, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl149, bgcolor: white"]K-Barn 115.1[/TD]
[TD="class: xl77, bgcolor: white"]Top[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]-[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]26.4[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]37.3[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]13.2[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]14.1[/TD]
[TD="class: xl78, bgcolor: white"]-[/TD]
[TD="class: xl69, bgcolor: white"]-[/TD]
[TD="class: xl79, bgcolor: white"]Bring to next boL[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]CL[/TD]
[TD="class: xl67, bgcolor: #F4B084"]BV[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments [/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Bottom[/TD]
[TD="class: xl80, bgcolor: transparent"]-[/TD]
[TD="class: xl81, bgcolor: transparent"]-[/TD]
[TD="class: xl80"]88.05[/TD]
[TD="class: xl81"]2.535[/TD]
[TD="class: xl80"]95.34[/TD]
[TD="class: xl81"]2.06[/TD]
[TD="class: xl80"]137.8[/TD]
[TD="class: xl81"]2.965[/TD]
[TD="class: xl80"]110.7[/TD]
[TD="class: xl81"]3.074[/TD]
[TD="class: xl80, bgcolor: transparent"]12[/TD]
[TD="class: xl81"]141[/TD]
[TD="class: xl82, bgcolor: white"]out of range-reduce[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Black[/TD]
[TD="class: xl67, bgcolor: #F4B084"]Green[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Bottom[/TD]
[TD="class: xl71, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"]-[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]0[/TD]
[TD="class: xl72, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]1[/TD]
[TD="class: xl82, bgcolor: white"]-[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #5B9BD5"] Location[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]February[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]March[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]April[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]May[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]June[/TD]
[TD="class: xl144, bgcolor: #5B9BD5, colspan: 2"]July[/TD]
[TD="class: xl70, bgcolor: #E7E6E6"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: white"]Top[/TD]
[TD="class: xl83, bgcolor: transparent"]1.00[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl84, bgcolor: transparent"]0.69[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl85, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"]-[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"]0.14[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl84, bgcolor: transparent"]0.36[/TD]
[TD="class: xl72, bgcolor: transparent"]MPY[/TD]
[TD="class: xl82, bgcolor: white"]Talked about last year[/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 98, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl88, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl89, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[TD="class: xl146, bgcolor: #5B9BD5, colspan: 12"]Action Items[/TD]
[TD="class: xl90, bgcolor: #5B9BD5"] [/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: #5B9BD5, colspan: 2"]Date Submitted[/TD]
[TD="class: xl91, bgcolor: #5B9BD5"]Follow up[/TD]
[/TR]
[TR]
[TD="class: xl148, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl92, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl140, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl93, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl140, width: 344, bgcolor: transparent, colspan: 2"]6/27/2017[/TD]
[TD="class: xl141, bgcolor: transparent, colspan: 12"]Bring up to team next months objective[/TD]
[TD="class: xl93, width: 416, bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl94, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl118, bgcolor: #5B9BD5, colspan: 15"]Con Report[/TD]
[/TR]
[TR]
[TD="class: xl95, width: 246, bgcolor: #5B9BD5"]Name[/TD]
[TD="class: xl96, width: 98, bgcolor: #5B9BD5"]Type[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]O, W, TF[/TD]
[TD="class: xl95, width: 75, bgcolor: #5B9BD5"]Run[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Target/day[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Actual/day[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Chem/Variance %[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Monthly Cost[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Cost[/TD]
[TD="class: xl97, width: 416, bgcolor: #5B9BD5"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: transparent"]EXP2[/TD]
[TD="class: xl100, bgcolor: transparent"]Green[/TD]
[TD="class: xl99, bgcolor: transparent"]TF[/TD]
[TD="class: xl99, bgcolor: transparent"]100[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]30.40[/TD]
[TD="class: xl128, bgcolor: transparent, colspan: 2"]32.00[/TD]
[TD="class: xl130, bgcolor: transparent, colspan: 2"]5%[/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 258.61 [/TD]
[TD="class: xl132, bgcolor: transparent, colspan: 2"] $ 1.15 [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl102, width: 246, bgcolor: yellow"]Totals[/TD]
[TD="class: xl103, width: 98, bgcolor: yellow"] [/TD]
[TD="class: xl104, bgcolor: yellow"] [/TD]
[TD="class: xl105, width: 75, bgcolor: yellow"] [/TD]
[TD="class: xl134, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl134, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl136, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl138, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl138, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl106, width: 416, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl87, width: 246, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 98, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl107, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl108, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl87, width: 75, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl109, bgcolor: #BFBFBF"] [/TD]
[/TR]
[TR]
[TD="class: xl118, bgcolor: #5B9BD5, colspan: 15"] Treat Report[/TD]
[/TR]
[TR]
[TD="class: xl95, width: 246, bgcolor: #5B9BD5"]Name[/TD]
[TD="class: xl95, width: 98, bgcolor: #5B9BD5"]Target[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"] gal/Stop[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Actual[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]Frequency[/TD]
[TD="class: xl96, width: 75, bgcolor: #5B9BD5"]Vol[/TD]
[TD="class: xl127, bgcolor: #5B9BD5, colspan: 2"]Variance %[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]Cost[/TD]
[TD="class: xl96, width: 150, bgcolor: #5B9BD5, colspan: 2"]$/BOE[/TD]
[TD="class: xl97, width: 416, bgcolor: #5B9BD5"]Comments[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl110, width: 246, bgcolor: transparent"]EXP1[/TD]
[TD="class: xl111, width: 98, bgcolor: transparent"]23[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl119, width: 150, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl112, width: 75, bgcolor: transparent"]1/M[/TD]
[TD="class: xl113, bgcolor: transparent"]2[/TD]
[TD="class: xl121, width: 150, bgcolor: transparent, colspan: 2"]12%[/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 27.44 [/TD]
[TD="class: xl123, width: 150, bgcolor: transparent, colspan: 2"] $ 9.35 [/TD]
[TD="class: xl114, width: 416, bgcolor: transparent"]Bad Month[/TD]
[/TR]
[TR]
[TD="class: xl103, width: 246, bgcolor: yellow"]Totals[/TD]
[TD="class: xl115, width: 98, bgcolor: yellow"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl103, width: 75, bgcolor: yellow"] [/TD]
[TD="class: xl116, bgcolor: yellow"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl125, width: 150, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl117, width: 416, bgcolor: yellow"] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
