Excel Formula

Excel INDIRECT function

How to use Excel’s INDIRECT function to refer to cells using the values entered into another cell. We show the basic method of how it works, and a more advanced example to refer to content in other worksheets.

Image of software function sign fx

Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Examples with syntax showing IFERROR then blank, IFERROR with VLOOKUP, IFERROR then perform another function.