INDIRECT

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.