i-nth logo
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.

Full article: Indirectly to the point