professor-excel.com
INDIRECT: How to Use Text as a Cell Reference in Excel
Instead of typing =A1, you could say =INDIRECT("A1"). In this article, you learn how to use INDIRECT, why it is very useful and why you should not use it.