Investment Studio > Expressions > Functions > Reference > INDIRECT

indirect (reference cell_reference)

Returns the value referenced by the string contained in the cell specified by cell_reference.

Step by step:

1. The value referenced by cell_reference is looked up. It must be a string.
2. The string is interpreted as a new cell reference.
3. The value referenced by the new cell reference is looked up and returned. This is the function result.

Schematically, cell_reference ® string, interpreted as reference ® value = result.

Example

If cell R2 in the Macro view's spreadsheet contains the string "D2", and cell D2 contains the value "C3PO",

=indirect(R2)

returns "C3PO".

See also address, offset.