Modify formula for data selection

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.
 

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

Open in new window

ChartFormula.xls
CartilloAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=INDEX(D2:P54,ROUNDDOWN((TODAY()-C2+6)/7,0),MATCH(S1,D61:P61,0))&"%"
0
 
Saqib Husain, SyedEngineerCommented:
Is this what you are looking for?

=INDEX(D66:P66,1,MATCH(S1,D1:P1,0))
0
 
Saqib Husain, SyedEngineerCommented:
or maybe

=INDEX(D2:P54,ROUNDDOWN((TODAY()-C2+6)/7,0),MATCH(S1,D61:P61,0))
0
 
CartilloAuthor Commented:
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.
0
 
CartilloAuthor Commented:
Thanks for the formula
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.