Data Validation With Tables & INDIRECT

If you’re going to use Data Validation in Excel, consider using Tables and the INDIRECT function. Here’s why…..

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!


  1. Data Validation Circle Invalid Data In #Excel | Excel Bytes - March 12, 2014

    […] Data Validation w/Tables & INDIRECT […]

  2. Three Flavors Of Drop Down Lists In #Excel | Excel Bytes - April 1, 2014

    […] Data Validation Part 1 – The List Data Validation Part 2 – Dates & Values Photos Tied To Drop Down Lists Data Validation Circle Invalid Data Limiting Survey Choices With Data Validation Dynamic Data Validation Lists Hyperlinks Using Data Validation Data Validation With Limiting Choices Data Validation With Tables & INDIRECT […]

Leave a Reply