1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Excel INDIRECT Function

By March 2, 2014

Follow me on:

Excel INDIRECT Function
Excel INDIRECT Function
© Ted French

The INDIRECT function, as its name suggests, can be used to indirectly reference a cell in a worksheet.

This is done by entering a cell reference as text string into the cell that is being read by the function.

INDIRECT converts this text string into a real cell reference, and then reads and displays the contents of this new cell.

Like many other Excel functions, on its own INDIRECT has limited usefulness. It is most effective when combined with other functions to create more complex formulas.

INDIRECT can be used with a number of functions that accept a cell reference as an argument, such as the SUM Function.

By combining the two, you can create a formula that lets you dynamically adjust the range of the SUM function without having to edit the formula itself.

To find out all the details of using this function, read this tutorial on the Excel INDIRECT Function.

Related Tutorials
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.