Wow, what a wonderful technique, you could employ each easy friendly function to be merged together to create something new, in another way; creating something from nothing. Thanks so much for your kind efforts
Respected sir, I see this video before you upload in ur channel but I need this switching situation after 2 years. Thanx for helping us 😊❤️ Regards Vijay
Hello! Thank you so much for this video, it was really helpful! Just wanted to let you know that when using the formula =indirect(vlookup(switching!....)) the excel finds an error and does not accept it. Instead I used the same formula as the vlookup (previous step) without using the word “switching” and worked just fine. I leave this comment in case anyone experiences the same problem as me. Thanks again!!
Yes, the sheet name is "Switch," and the similar Defined Name "Switching" was accidentally typed. He went pretty fast through that part. I love the results, though, and hope he'll get around to a follow-up.
Hi Bro. I have a small issue when am trying to switch the table as you mentioned after your final step always pop in this message. Reference isn't valid. Still i could not overcome with this. would appreciate if you could help me out.
Thank you! This is beautiful but surely there is a little issue. When we change the name from range to Switching. We can change from one chart to another but if I choose Source Table, It will show you the last chart you chose. It does not show you just the Source Table. Is this the way it should behave? Thanks
Brother. I created as same by step by step. But switching only one year and table is changing ...the remaining 3 yr is not reflecting wile switching ..how to solve this ?
Hi, Thanks a lot for this instructive video. It seriously helped me a lot. Could you please elaborate how I can transfer this to my dashboard once I am done?
If I want to display the dropdown box and the linked chart on a PowerPoint presentation so that I can choose the required chart and it will dynamically change on the ppt, how do I do that?
![Chino Pacas - Modo Capone (with Drake & Fuerza Regida) [Video Oficial]](http://i.ytimg.com/vi/zjv8TQ0gBkg/mqdefault.jpg)
Exactly what I have been looking for to use in my HR Metrics Dashboard and not using slicers but a drop down menu. Thank you! Easy video to follow!
You saved my day! Big thank you for sharing knowledge
Wow, what a wonderful technique, you could employ each easy friendly function to be merged together to create something new, in another way; creating something from nothing. Thanks so much for your kind efforts
Respected sir,
I see this video before you upload in ur channel but I need this switching situation after 2 years.
Thanx for helping us 😊❤️
Regards
Vijay
Most welcome
Thank you very much sir for the neat explanation, it worked fabulously.
Amazing!!!
Hello! Thank you so much for this video, it was really helpful! Just wanted to let you know that when using the formula =indirect(vlookup(switching!....)) the excel finds an error and does not accept it. Instead I used the same formula as the vlookup (previous step) without using the word “switching” and worked just fine. I leave this comment in case anyone experiences the same problem as me. Thanks again!!
Yes, the sheet name is "Switch," and the similar Defined Name "Switching" was accidentally typed. He went pretty fast through that part. I love the results, though, and hope he'll get around to a follow-up.
amazing technique, learn a lot from you. Thank you
Thank you for the nice comment
Mach'Allah, you are so great brother Nabil. Keep going!
Thank you
Splendid video! This is like Camera tool option; I mean from the principle.
Indeed it is!
@@Officeinstructor at last while adding switching in the formula bar it is showing reference is not valid
@@piyushjain009 Note that you Must precede the cell reference with the worksheet name when defining names
Hello , Thank you very much for the solution. it is very easy & great.
Excellent 👍👍 Thanks for sharing..
Hi Bro. I have a small issue when am trying to switch the table as you mentioned after your final step always pop in this message. Reference isn't valid. Still i could not overcome with this. would appreciate if you could help me out.
Fantastic! Thank you!
You're very welcome!
Thank you! This is beautiful but surely there is a little issue. When we change the name from range to Switching. We can change from one chart to another but if I choose Source Table, It will show you the last chart you chose. It does not show you just the Source Table. Is this the way it should behave? Thanks
Excellent!
Thank you
Brother. I created as same by step by step. But switching only one year and table is changing ...the remaining 3 yr is not reflecting wile switching ..how to solve this ?
It's fantastic technic...tks!
Glad you like it!
Hello sir. Do u have the video where we put the charts in a dashboard. Thank u
Simple way dear everything is show in this video
This is excellent
Thank you
Hi, Thanks a lot for this instructive video. It seriously helped me a lot. Could you please elaborate how I can transfer this to my dashboard once I am done?
Will try to do that shortly
Your are brilliant
Thank you
If I want to display the dropdown box and the linked chart on a PowerPoint presentation so that I can choose the required chart and it will dynamically change on the ppt, how do I do that?
I do have a video on creating a Pivot Table in Excel and modify it in PPT. You'll find it in my channel
Excelent Mr Nail.
Wow wonderful this videos sir....
Great
Superb !!
At last when I am adding switching in the formula bar it is showing reference is invalid
=Indirect(VLOOKUP(Switch *either remove the word "Switch" or rename it same with the name of your sheet name*
@@angela4598 still invalid :(
How if we dont need user friendly names...?
Then you are saving some steps.