Data Validation Made Easy: Learn How to Use INDIRECT Function

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.com
#excel #exceltutorial #exceltips

[@drewsoffice]

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

[@rodyeltabaa6871]

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]

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

[@marcogiubar]

Great music! And the tips too!

[@drewsoffice]

Glad you liked it!

[@stewartwilkinsonsnr]

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

[@drewsoffice]

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

[@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.

[@drewsoffice]

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.
[e-mail]

[@cesarpena-quevedo8033]

I got an error when using the INDIRECT function

[@drewsoffice]

Can you share more details?