Indirectly to the point
14 September 2013
Using Named Ranges in your work in Excel is a highly recommended Best Practice. A problem may arise when trying to refer a Named Range, however. The solution is mastering the easy-to-use Indirect Function!
Using the Indirect Function, along with Validation, is an easy way to make a truly powerful interactive report.