Excel INDIRECT Function Tips

Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed?

We often have sheets with similar tables and with similar layout.

**INDIRECT Function** yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell.

The INDIRECT function is a powerful function as it allows you to carry out different tasks that come in very handy.