Data Validation Made Easy: Learn How to Use INDIRECT Function #microsoftexcel #excelforbeginners

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.

#excel #exceltutorial #exceltips

[drewsoffice]

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

[stewartwilkinsonsnr]

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

[rodyeltabaa]

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 😊

[Van_Wilder]

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.

[freepilot]

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.?

[cesarpena-quevedo]

I got an error when using the INDIRECT function