Populate Cell Based on Input

C

capex

New Member
Joined
Apr 18, 2009
Messages
44
I have a sheet with month and related value in columns A,B,C...

Want to find out following
1. Based on input from H1, which has drop down menu which contains A,B,C,D,E,F.
2. I want to be able to pick for example A (from drop down menu H1)and populate column J with values of column A.
3. Do not want to use pivot table.

Thank you for your help and time in advance.

Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: center;;">Months</td><td style="text-align: center;;">A</td><td style="text-align: center;;">B</td><td style="text-align: center;;">C</td><td style="text-align: center;;">D</td><td style="text-align: center;;">E</td><td style="text-align: center;;">F</td><td style="text-align: center;background-color: #FFFF00;;">A</td><td style="text-align: right;;">
</td><td style="text-align: center;;">Values</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">Aug-09</td><td style="text-align: right;;">95968</td><td style="text-align: right;;">498421</td><td style="text-align: right;;">98784</td><td style="text-align: right;;">155211</td><td style="text-align: center;;">0</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Aug-09</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">Sep-09</td><td style="text-align: right;;">96471</td><td style="text-align: right;;">499002</td><td style="text-align: right;;">148847</td><td style="text-align: right;;">155228</td><td style="text-align: center;;">0</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Sep-09</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">Oct-09</td><td style="text-align: right;;">95608</td><td style="text-align: right;;">506895</td><td style="text-align: right;;">148435</td><td style="text-align: right;;">155058</td><td style="text-align: center;;">0</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Oct-09</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">Nov-09</td><td style="text-align: right;;">95692</td><td style="text-align: right;;">507498</td><td style="text-align: right;;">148583</td><td style="text-align: right;;">148583</td><td style="text-align: right;;">148443</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Nov-09</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">Dec-09</td><td style="text-align: right;;">95555</td><td style="text-align: right;;">506278</td><td style="text-align: right;;">147975</td><td style="text-align: right;;">147975</td><td style="text-align: right;;">150236</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Dec-09</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">Jan-10</td><td style="text-align: right;;">101830</td><td style="text-align: right;;">503846</td><td style="text-align: right;;">144151</td><td style="text-align: right;;">144151</td><td style="text-align: right;;">144308</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jan-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">Feb-10</td><td style="text-align: right;;">102565</td><td style="text-align: right;;">504336</td><td style="text-align: right;;">144071</td><td style="text-align: right;;">144071</td><td style="text-align: right;;">146224</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Feb-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">Mar-10</td><td style="text-align: right;;">103767</td><td style="text-align: right;;">507518</td><td style="text-align: right;;">144845</td><td style="text-align: right;;">144845</td><td style="text-align: right;;">148410</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Mar-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">Apr-10</td><td style="text-align: right;;">129404</td><td style="text-align: right;;">507475</td><td style="text-align: right;;">144754</td><td style="text-align: right;;">144754</td><td style="text-align: right;;">149014</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Apr-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">May-10</td><td style="text-align: right;;">127864</td><td style="text-align: right;;">502625</td><td style="text-align: right;;">143633</td><td style="text-align: right;;">143633</td><td style="text-align: right;;">145272</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">May-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">Jun-10</td><td style="text-align: right;;">124562</td><td style="text-align: right;;">492448</td><td style="text-align: right;;">140768</td><td style="text-align: right;;">140768</td><td style="text-align: right;;">141248</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jun-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">Jul-10</td><td style="text-align: right;;">126840</td><td style="text-align: right;;">496466</td><td style="text-align: right;;">141947</td><td style="text-align: right;;">141947</td><td style="text-align: right;;">142737</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jul-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">Aug-10</td><td style="text-align: right;;">125063</td><td style="text-align: right;;">489914</td><td style="text-align: right;;">140113</td><td style="text-align: right;;">140113</td><td style="text-align: right;;">140180</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Aug-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">Sep-10</td><td style="text-align: right;;">129905</td><td style="text-align: right;;">504277</td><td style="text-align: right;;">144827</td><td style="text-align: right;;">144827</td><td style="text-align: right;;">146170</td><td style="text-align: center;;">0</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Sep-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">Oct-10</td><td style="text-align: right;;">133050</td><td style="text-align: right;;">511902</td><td style="text-align: right;;">147387</td><td style="text-align: right;;">147387</td><td style="text-align: right;;">149314</td><td style="text-align: right;;">100278</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Oct-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">Nov-10</td><td style="text-align: right;;">132979</td><td style="text-align: right;;">489512</td><td style="text-align: right;;">147219</td><td style="text-align: right;;">147219</td><td style="text-align: right;;">148785</td><td style="text-align: right;;">99310</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Nov-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">Dec-10</td><td style="text-align: right;;">158708</td><td style="text-align: right;;">502889</td><td style="text-align: right;;">202916</td><td style="text-align: right;;">202916</td><td style="text-align: right;;">155763</td><td style="text-align: right;;">101668</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Dec-10</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">Jan-11</td><td style="text-align: right;;">168095</td><td style="text-align: right;;">497287</td><td style="text-align: right;;">201496</td><td style="text-align: right;;">201496</td><td style="text-align: right;;">175215</td><td style="text-align: right;;">98943</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jan-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">Feb-11</td><td style="text-align: right;;">171786</td><td style="text-align: right;;">500137</td><td style="text-align: right;;">204553</td><td style="text-align: right;;">204553</td><td style="text-align: right;;">175191</td><td style="text-align: right;;">102850</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Feb-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">Mar-11</td><td style="text-align: right;;">172710</td><td style="text-align: right;;">498113</td><td style="text-align: right;;">203566</td><td style="text-align: right;;">203566</td><td style="text-align: right;;">174090</td><td style="text-align: right;;">102271</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Mar-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">Apr-11</td><td style="text-align: right;;">179262</td><td style="text-align: right;;">513085</td><td style="text-align: right;;">209923</td><td style="text-align: right;;">209923</td><td style="text-align: right;;">182402</td><td style="text-align: right;;">106808</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Apr-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">May-11</td><td style="text-align: right;;">170223</td><td style="text-align: right;;">499607</td><td style="text-align: right;;">202154</td><td style="text-align: right;;">202154</td><td style="text-align: right;;">175156</td><td style="text-align: right;;">101637</td><td style="text-align: right;;">
</td><td style="text-align: right;;">May-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">Jun-11</td><td style="text-align: right;;">167403</td><td style="text-align: right;;">491695</td><td style="text-align: right;;">198481</td><td style="text-align: right;;">198481</td><td style="text-align: right;;">172076</td><td style="text-align: right;;">150379</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jun-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr><tr><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">Jul-11</td><td style="text-align: right;;">169251</td><td style="text-align: right;;">497090</td><td style="text-align: right;;">200640</td><td style="text-align: right;;">200640</td><td style="text-align: right;;">173894</td><td style="text-align: right;;">152061</td><td style="text-align: right;;">
</td><td style="text-align: right;;">Jul-11</td><td style="text-align: right;background-color: #FFFF00;;">
</td></tr></tbody></table>
Sheet5​



 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
capex said:
I have a sheet with month and related value in columns A,B,C...

Want to find out following
1. Based on input from H1, which has drop down menu which contains A,B,C,D,E,F.
2. I want to be able to pick for example A (from drop down menu H1)and populate column J with values of column A.
3. Do not want to use pivot table.

Thank you for your help and time in advance.

Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH>

</TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">Months</TD><TD style="TEXT-ALIGN: center">A</TD><TD style="TEXT-ALIGN: center">B</TD><TD style="TEXT-ALIGN: center">C</TD><TD style="TEXT-ALIGN: center">D</TD><TD style="TEXT-ALIGN: center">E</TD><TD style="TEXT-ALIGN: center">F</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">A</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: center">Values</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">Aug-09</TD><TD style="TEXT-ALIGN: right">95968</TD><TD style="TEXT-ALIGN: right">498421</TD><TD style="TEXT-ALIGN: right">98784</TD><TD style="TEXT-ALIGN: right">155211</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Aug-09</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">Sep-09</TD><TD style="TEXT-ALIGN: right">96471</TD><TD style="TEXT-ALIGN: right">499002</TD><TD style="TEXT-ALIGN: right">148847</TD><TD style="TEXT-ALIGN: right">155228</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Sep-09</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">Oct-09</TD><TD style="TEXT-ALIGN: right">95608</TD><TD style="TEXT-ALIGN: right">506895</TD><TD style="TEXT-ALIGN: right">148435</TD><TD style="TEXT-ALIGN: right">155058</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Oct-09</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: right">Nov-09</TD><TD style="TEXT-ALIGN: right">95692</TD><TD style="TEXT-ALIGN: right">507498</TD><TD style="TEXT-ALIGN: right">148583</TD><TD style="TEXT-ALIGN: right">148583</TD><TD style="TEXT-ALIGN: right">148443</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Nov-09</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: right">Dec-09</TD><TD style="TEXT-ALIGN: right">95555</TD><TD style="TEXT-ALIGN: right">506278</TD><TD style="TEXT-ALIGN: right">147975</TD><TD style="TEXT-ALIGN: right">147975</TD><TD style="TEXT-ALIGN: right">150236</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Dec-09</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">7</TD><TD style="TEXT-ALIGN: right">Jan-10</TD><TD style="TEXT-ALIGN: right">101830</TD><TD style="TEXT-ALIGN: right">503846</TD><TD style="TEXT-ALIGN: right">144151</TD><TD style="TEXT-ALIGN: right">144151</TD><TD style="TEXT-ALIGN: right">144308</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jan-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: right">Feb-10</TD><TD style="TEXT-ALIGN: right">102565</TD><TD style="TEXT-ALIGN: right">504336</TD><TD style="TEXT-ALIGN: right">144071</TD><TD style="TEXT-ALIGN: right">144071</TD><TD style="TEXT-ALIGN: right">146224</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Feb-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">9</TD><TD style="TEXT-ALIGN: right">Mar-10</TD><TD style="TEXT-ALIGN: right">103767</TD><TD style="TEXT-ALIGN: right">507518</TD><TD style="TEXT-ALIGN: right">144845</TD><TD style="TEXT-ALIGN: right">144845</TD><TD style="TEXT-ALIGN: right">148410</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Mar-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: right">Apr-10</TD><TD style="TEXT-ALIGN: right">129404</TD><TD style="TEXT-ALIGN: right">507475</TD><TD style="TEXT-ALIGN: right">144754</TD><TD style="TEXT-ALIGN: right">144754</TD><TD style="TEXT-ALIGN: right">149014</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Apr-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: right">May-10</TD><TD style="TEXT-ALIGN: right">127864</TD><TD style="TEXT-ALIGN: right">502625</TD><TD style="TEXT-ALIGN: right">143633</TD><TD style="TEXT-ALIGN: right">143633</TD><TD style="TEXT-ALIGN: right">145272</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">May-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: right">Jun-10</TD><TD style="TEXT-ALIGN: right">124562</TD><TD style="TEXT-ALIGN: right">492448</TD><TD style="TEXT-ALIGN: right">140768</TD><TD style="TEXT-ALIGN: right">140768</TD><TD style="TEXT-ALIGN: right">141248</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jun-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: right">Jul-10</TD><TD style="TEXT-ALIGN: right">126840</TD><TD style="TEXT-ALIGN: right">496466</TD><TD style="TEXT-ALIGN: right">141947</TD><TD style="TEXT-ALIGN: right">141947</TD><TD style="TEXT-ALIGN: right">142737</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jul-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">14</TD><TD style="TEXT-ALIGN: right">Aug-10</TD><TD style="TEXT-ALIGN: right">125063</TD><TD style="TEXT-ALIGN: right">489914</TD><TD style="TEXT-ALIGN: right">140113</TD><TD style="TEXT-ALIGN: right">140113</TD><TD style="TEXT-ALIGN: right">140180</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Aug-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">15</TD><TD style="TEXT-ALIGN: right">Sep-10</TD><TD style="TEXT-ALIGN: right">129905</TD><TD style="TEXT-ALIGN: right">504277</TD><TD style="TEXT-ALIGN: right">144827</TD><TD style="TEXT-ALIGN: right">144827</TD><TD style="TEXT-ALIGN: right">146170</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Sep-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">16</TD><TD style="TEXT-ALIGN: right">Oct-10</TD><TD style="TEXT-ALIGN: right">133050</TD><TD style="TEXT-ALIGN: right">511902</TD><TD style="TEXT-ALIGN: right">147387</TD><TD style="TEXT-ALIGN: right">147387</TD><TD style="TEXT-ALIGN: right">149314</TD><TD style="TEXT-ALIGN: right">100278</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Oct-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">17</TD><TD style="TEXT-ALIGN: right">Nov-10</TD><TD style="TEXT-ALIGN: right">132979</TD><TD style="TEXT-ALIGN: right">489512</TD><TD style="TEXT-ALIGN: right">147219</TD><TD style="TEXT-ALIGN: right">147219</TD><TD style="TEXT-ALIGN: right">148785</TD><TD style="TEXT-ALIGN: right">99310</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Nov-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">18</TD><TD style="TEXT-ALIGN: right">Dec-10</TD><TD style="TEXT-ALIGN: right">158708</TD><TD style="TEXT-ALIGN: right">502889</TD><TD style="TEXT-ALIGN: right">202916</TD><TD style="TEXT-ALIGN: right">202916</TD><TD style="TEXT-ALIGN: right">155763</TD><TD style="TEXT-ALIGN: right">101668</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Dec-10</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">19</TD><TD style="TEXT-ALIGN: right">Jan-11</TD><TD style="TEXT-ALIGN: right">168095</TD><TD style="TEXT-ALIGN: right">497287</TD><TD style="TEXT-ALIGN: right">201496</TD><TD style="TEXT-ALIGN: right">201496</TD><TD style="TEXT-ALIGN: right">175215</TD><TD style="TEXT-ALIGN: right">98943</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jan-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">20</TD><TD style="TEXT-ALIGN: right">Feb-11</TD><TD style="TEXT-ALIGN: right">171786</TD><TD style="TEXT-ALIGN: right">500137</TD><TD style="TEXT-ALIGN: right">204553</TD><TD style="TEXT-ALIGN: right">204553</TD><TD style="TEXT-ALIGN: right">175191</TD><TD style="TEXT-ALIGN: right">102850</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Feb-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">21</TD><TD style="TEXT-ALIGN: right">Mar-11</TD><TD style="TEXT-ALIGN: right">172710</TD><TD style="TEXT-ALIGN: right">498113</TD><TD style="TEXT-ALIGN: right">203566</TD><TD style="TEXT-ALIGN: right">203566</TD><TD style="TEXT-ALIGN: right">174090</TD><TD style="TEXT-ALIGN: right">102271</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Mar-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">22</TD><TD style="TEXT-ALIGN: right">Apr-11</TD><TD style="TEXT-ALIGN: right">179262</TD><TD style="TEXT-ALIGN: right">513085</TD><TD style="TEXT-ALIGN: right">209923</TD><TD style="TEXT-ALIGN: right">209923</TD><TD style="TEXT-ALIGN: right">182402</TD><TD style="TEXT-ALIGN: right">106808</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Apr-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">23</TD><TD style="TEXT-ALIGN: right">May-11</TD><TD style="TEXT-ALIGN: right">170223</TD><TD style="TEXT-ALIGN: right">499607</TD><TD style="TEXT-ALIGN: right">202154</TD><TD style="TEXT-ALIGN: right">202154</TD><TD style="TEXT-ALIGN: right">175156</TD><TD style="TEXT-ALIGN: right">101637</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">May-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">24</TD><TD style="TEXT-ALIGN: right">Jun-11</TD><TD style="TEXT-ALIGN: right">167403</TD><TD style="TEXT-ALIGN: right">491695</TD><TD style="TEXT-ALIGN: right">198481</TD><TD style="TEXT-ALIGN: right">198481</TD><TD style="TEXT-ALIGN: right">172076</TD><TD style="TEXT-ALIGN: right">150379</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jun-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>

</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">25</TD><TD style="TEXT-ALIGN: right">Jul-11</TD><TD style="TEXT-ALIGN: right">169251</TD><TD style="TEXT-ALIGN: right">497090</TD><TD style="TEXT-ALIGN: right">200640</TD><TD style="TEXT-ALIGN: right">200640</TD><TD style="TEXT-ALIGN: right">173894</TD><TD style="TEXT-ALIGN: right">152061</TD><TD style="TEXT-ALIGN: right"></B>

</TD><TD style="TEXT-ALIGN: right">Jul-11</TD><TD style="BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: right"></B>
​
</TD></TR></TBODY></TABLE>Sheet5</B>
Click to expand...
Try this...

Entered in J2 and copied down as needed:

=INDEX(B$2:G$25,ROWS(J$2:J2),MATCH(H$1,B$1:G$1,0))
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
VBA code clean up
Replies
9
Views
582
mumps
mumps
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
J
  • Question Question
Populate a range of cells to end up with a given total, Solver? Formula?
Replies
3
Views
85
NdNoviceHlp
NdNoviceHlp
D
  • Question Question
Looking for a way to allocate shifts between teams, maybe a LET formula
Replies
0
Views
89
Dazzybeeguy
D
F
  • Question Question
VBA Macro Issue: Replacing Simple Formula with Complex Formula Causes Error
Replies
2
Views
105
flashgordie
F

Forum statistics

Threads
1,224,586
Messages
6,179,707
Members
452,939
Latest member
WCrawford

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