Investment Studio > Expressions > Functions > Reference
Also see Matrix functions.
| Result type | Function name | Arguments |
| string | address | (integer row_number, integer column_number, integer absolute = 1) |
| array | array | (reference cell_reference) |
| choose | (integer argument_index, argument [, ...]) | |
| integer | column | () |
| integer | (reference cell_reference) | |
| integer array[1][*] | (reference range_reference) | |
| integer | columns | (array[*][*] argument) |
| hlookup | (lookup_value, array[*][*] table, integer result_row = 1, boolean range_lookup = TRUE) | |
| index | (array[*][*] table, integer row = 0, integer column = 0) | |
| indirect | (reference cell_reference) | |
| lookup | (lookup_value, array[*][*] table) | |
| (lookup_value, array values, array results) | ||
| integer | match | (lookup_value, array[*][*] table, integer match_type = 1) |
| reference | offset | (reference base_reference, integer rows, integer columns, integer height = 0, integer width = 0) |
| integer | row | () |
| integer | (reference cell_reference) | |
| integer array[*][1] | (reference range_reference) | |
| integer | rows | (array argument) |
| array[*][*] | subarray | (array[*][*] source_array, integer start_row, integer end_row, integer start_column, integer end_column) |
| vlookup | (lookup_value, array[*][*] table, integer result_column = 1, boolean range_lookup = TRUE) |