Data Validation Made Easy: Learn How to Use INDIRECT Function

No video

Data Validation Made Easy: Learn How to Use INDIRECT Function

Рет қаралды 4,698

Жыл бұрын

ABOUT THIS VIDEO
Unlock Validation Magic: Master INDIRECT & Level Up Your Excel Data Control! Conquering Excel's INDIRECT function is easier than you think! This beginner-friendly tutorial shows you how to use it for dynamic validation lists, cascading dropdowns, and more. Say goodbye to rigid and frustrating options! Master INDIRECT and say hello to powerful, flexible validation that adapts to your needs. No more manual editing or errors, just clean, controlled data in your spreadsheets.
LIVE ONLINE TRAINING
Drew Ennis brings his enthusiastic delivery straight to your home or workplace via live online interactive training sessions.
Do you need 1:1 training to help you upskill?
Or perhaps you prefer to learn with others in a small group?
Attend a short course with Drews Office and experience learner-focused training in a relaxed atmosphere. You will be in safe hands, as Drew has 30+ experience, and will coach you in a way that suits your pace and personal needs.
For more information go to our website.
WEBSITE: www.drewsoffice...
#excel #exceltutorial #exceltips

Пікірлер: 14

@drewsoffice 6 ай бұрын

🤔 Got Excel Questions? 🚀 Drop your thoughts below and let's tackle Excel together!

@rodyeltabaa6871 7 ай бұрын

Nice video. I have found a efficient and simple way to reference to every table in workbook in a drop down list then reference to its headers in another drop down list and finally get a unique list of that column in a 3rd dependent drop down list.... only using the indirect fuction.... happy to share my findings with you 😊

@drewsoffice 7 ай бұрын

Thanks. Your method sounds interesting...please do share

@marcogiubar 7 ай бұрын

Great music! And the tips too!

@drewsoffice 7 ай бұрын

Glad you liked it!

@stewartwilkinsonsnr 6 ай бұрын

Excellent video just what I needed to set up my excel spreadsheet many thanks 👍👏

@drewsoffice 6 ай бұрын

Thank you very much for taking the time to message. Glad the video was helpful

@Van_Wilder 3 ай бұрын

Hi there, instead of using three rows for three different selections, I’ve made mine to be one. Everything works well but I was wondering if there’s a way that after one has gone and changed your selection to a different continent, is it possible to have the first country of the newly selected continent show up dynamically in the drop down list. Currently everything changes to the correct drop down list in background but you’ll only notice it once you make a country selection. Prior to making a selection, the country from the previous continent still shows up after you’ve changed continent.

@drewsoffice 3 ай бұрын

Hi Van - thanks for your message. According to how you describe, this can be achieved using the VLOOKUP function. If you email your spreadsheet to me, I will take a look and find a solution for you. info@drewsoffice.com

@freepilot7732 Ай бұрын

Great job.... If I may ask for help? Is this possible? Could the dependant list be dynamic and it applies it to the drop down list? Example... Cell A1 is my dropdown list location. If B2=1.Then.... The drop down list (A1) will show. A, B, C to choose. BUT.... If B2=2 Then A1 drop down list will automatically change the choices to D, E, F. Continued.... But If B2=3 Then my drop down list in A1 will now show choices G, H, I, J, K. Another words your dependent list still changes it's list of choices based on your CONTINENT value but that value isn't selected from a list but a value provided by being typed in or provided elsewhere yet again your dependent list so changes.?

@drewsoffice Ай бұрын

Hi. Yes this is possible with the IF or IFS function. You would need to nest separate INDIRECT statements inside the IF statement to call the different named ranges. Send me your spreadsheet, I will have a look for you :)

@freepilot7732 Ай бұрын

I appreciate your quick response. Funny how just asking the question and following your video I figured it out and it works. After Two months of trying. Thank you. Cheers.