INDIRECT - Superhero when nothing directly works
A bitter sweet and not a strong love affair for many, INDIRECT function is one of those that are avoided most of the time by Excel heads. I don’t blame INDIRECT function for its patchy nature as the scenarios that require its use are dodgy in itself.
But what I love about this function is that many a times it just just does the job like no other. The basic task of this function is to return cell reference by processing text string. This ability is much valuable.
Following are some of the tutorials where INDIRECT function is used:
