<div>
Is this what you are looking for? <br />
<br />
=INDEX(D66:P66,1,MATCH(S1,<wbr />D1:P1,0))
</div>


Is this what you are looking for?

=INDEX(D66:P66,1,MATCH(S1,D1:P1,0))

<div>
or maybe<br />
<br />
=INDEX(D2:P54,ROUNDDOWN((T<wbr />ODAY()-C2+<wbr />6)/7,0),MA<wbr />TCH(S1,D61<wbr />:P61,0))
</div>


or maybe

=INDEX(D2:P54,ROUNDDOWN((TODAY()-C2+6)/7,0),MATCH(S1,D61:P61,0))

<div>
Hi Saqib, <br />
<br />
Thanks for the formula, this is what I'm looking for:<br />
<br />
=INDEX(D66:P66,1,MATCH(S1,<wbr />D1:P1,0))<br />
<br />
<br />
Is that possible to add &quot;%&quot; sign automatically without distracting the data value. 
</div>


Hi Saqib,

Thanks for the formula, this is what I'm looking for:

=INDEX(D66:P66,1,MATCH(S1,D1:P1,0))


Is that possible to add "%" sign automatically without distracting the data value.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I would like to request Experts help to modify the attached formula to allow data automatically shows a specific &nbsp;data from cell D66:N66 at cell G59 (chart sheet) based on data displayed at cell S1 (chart sheet). E.g if cell S1 showed “TH1” therefore cell at G59 will display 100.00 (D66). If “TH5” was displayed at S1 cell, data at cell G59 will display data from cell H66 (97.33). The S1 data &nbsp;display is controllable &nbsp;at Chart 2 with spinner selection. Hope Experts will help me to modify this formula.<br />
&nbsp;<br />
<br />

<pre><code id="code-8142288">=INDEX(D2:P54,ROUNDDOWN((TODAY()-C2+6)/7,0),MATCH(S1,D1:P1,0))</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2011/04_w17/446820/ChartFormula.xls" target="_blank" class="file-inline" title="xls (233 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ChartFormula.xls</a>
</div>
</div>


ChartFormula.xls

Hi Experts,

I would like to request Experts help to modify the attached formula to allow data automatically shows a specific  data from cell D66:N66 at cell G59 (chart sheet) based on data displayed at cell S1 (chart sheet). E.g if cell S1 showed “TH1” therefore cell at G59 will display 100.00 (D66). If “TH5” was displayed at S1 cell, data at cell G59 will display data from cell H66 (97.33). The S1 data  display is controllable  at Chart 2 with spinner selection. Hope Experts will help me to modify this formula.
 


Modify formula for data selection

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.