akinkaraman
Member
I need a formula for D6 which shows the result from the chart..
Need a formula..
- Thread starter akinkaraman
- Start date
Somendra Misra
Excel Ninja
Hi,
See your file.
Regards,
See your file.
Regards,
akinkaraman
Member
Thank you but this is a speacial formula which only works here and I can not copy it to the original file which I can not share here.. 
Originally the chart is in another page.. Like, I will write the formula into Page 1 and the chart is in Page 2.
Originally the chart is in another page.. Like, I will write the formula into Page 1 and the chart is in Page 2.
Last edited:
Somendra Misra
Excel Ninja
The formula in D6 is common, but there is named formula Datasel as given below:
=CHOOSE(VLOOKUP(Sayfa1!$D$2,{"A",1;"B",2;"C",3},2,0),Sayfa1!$C$12:$I$14,Sayfa1!$C$19:$I$21,Sayfa1!$C$26:$I$28)
Here change the references in red to your sheet2 references.
Regards,
=CHOOSE(VLOOKUP(Sayfa1!$D$2,{"A",1;"B",2;"C",3},2,0),Sayfa1!$C$12:$I$14,Sayfa1!$C$19:$I$21,Sayfa1!$C$26:$I$28)
Here change the references in red to your sheet2 references.
Regards,
akinkaraman
Member
How will I label Datasel formula? I don't know how to give the reference.
Can you teach me?
Can you teach me?
Somendra Misra
Excel Ninja
Does your Index type are A , B & C only or there are more?
Regards,
Regards,
akinkaraman
Member
Only 3
Somendra Misra
Excel Ninja
See the file.
I had move chart data on Safya2 Sheet. Go to Name manager from formula tab or Ctrl+F3 shortcut, the ref. are updated automatically, if you cut and paste the data from sheet1 to sheet2.
Regards,
I had move chart data on Safya2 Sheet. Go to Name manager from formula tab or Ctrl+F3 shortcut, the ref. are updated automatically, if you cut and paste the data from sheet1 to sheet2.
Regards,
akinkaraman
Member
It is not working because I still couldn't show the table with this formula..
=>
=CHOOSE(VLOOKUP(Sayfa1!$D$2,{"A",1;"B",2;"C",3},2,0),Sayfa1!$C$12:$I$14,Sayfa1!$C$19:$I$21,Sayfa1!$C$26:$I$28)
Where can I use this?
=>
=CHOOSE(VLOOKUP(Sayfa1!$D$2,{"A",1;"B",2;"C",3},2,0),Sayfa1!$C$12:$I$14,Sayfa1!$C$19:$I$21,Sayfa1!$C$26:$I$28)
Where can I use this?
Somendra Misra
Excel Ninja
1. Press Ctrl+F3
Name manager dialog box will open.
Than press New
Give a name "DataSel"
In Refers to : put the formula.
Press OK.
Than you can use datasel in any other formula.
Regards,
Name manager dialog box will open.
Than press New
Give a name "DataSel"
In Refers to : put the formula.
Press OK.
Than you can use datasel in any other formula.
Regards,
Ratan Bhushan
Member
Superlike
Somendra Misra
Excel Ninja
akinkaraman
Member
Superlike too Thank you very much..
Thank you very much..
akinkaraman
Member
I found one more solutıon which is so simple. I want to share it..