GetValueAt
The GetValueAt() function returns a value from a specified position in an array.
Note:
GetValueAt() is an old function that is interchangeable with the Excel Index() function. Index() should be used in place of GetValueAt().
Syntax
GetValueAt (Array, Column, Row)
| Array | An input array |
| Column | The column to evaluate |
| Row | The row to evaluate |
Examples
| Input array | ||
| A | 1 | 11 |
| B | 2 | 22 |
| C | 3 | 33 |
| D | 4 | 44 |
| E | 5 | 55 |
| F | 6 | 66 |
| G | 7 | 77 |
| Function | Output |
| GetValueAt(Array,1,1) | A |
| GetValueAt(Array,3,7) | 77 |
| GetValueAt(Array,2,2) | 2 |
| GetValueAt(Array,1,7) | G |