This Excel tutorial explains how to use the Excel INDIRECT function with syntax and examples.
Description
- Select the Camera tool icon in the Quick Access toolbar. Click the worksheet in the location where you want to place the picture. Excel immediately creates a live picture of the entire range, as shown in this figure. Changing any number in the original range automatically causes the picture to update.
- Camera tool is your way of creating visual reference in an excel sheet. It is one of the useful and hidden features of excel. Here is how it works. You specify a rectangular area in your workbook and camera tool creates a mirror image of that area as a drawing object. You can move it or resize it. And whenever the contents of original rectangular area changes (charts, drawings or cell values.
This video shows you how to add the new camera function in Excel 2016 and some of the default layouts and borders that are available in it. Why is this good? You can select some cells.
The Microsoft Excel INDIRECT function returns the reference to a cell based on its string representation.
The INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDIRECT function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the INDIRECT function in Microsoft Excel is:
Parameters or Arguments
- string_reference
- A textual representation of a cell reference.
- ref_style
- Optional. It is either a TRUE or FALSE value. TRUE indicates that string_reference will be interpreted as an A1-style reference. FALSE indicates that string_reference will be interpreted as an R1C1-style reference. If this parameter is omitted, it will interpret string_reference as an A1-style.
Returns
The INDIRECT function returns the reference to a cell and thus displays the referenced cell's value.
Tools In Excel 2016
Applies To
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Example (as Worksheet Function)
Camera In Excel 2016 Spreadsheets
Let's look at some Excel INDIRECT function examples and explore how to use the INDIRECT function as a worksheet function in Microsoft Excel:
Camera In Excel 2016
Based on the Excel spreadsheet above, the following INDIRECT examples would return: