GetValueAt
The GetValueAt() function returns the value located at a specified row and column position in an array.
Syntax:
GetValueAt(Array, Column, Row)- In the Quintessence Editor (Studio) using Python language, use:
Qx.GetValueAt()
ⓘ See parameter descriptions
| Array | The input string to search. |
| Column | The column number to retrieve (1‑based index). |
| Row | The row number to retrieve (1‑based index). |
Remarks:
GetValueAt()is an older function and is interchangeable with the ExcelIndex()function. It is recommended to useIndex()instead ofGetValueAt().
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Return the value at a specific column and row
Range:
| A | 1 | 11 |
| B | 2 | 22 |
| C | 3 | 33 |
Formula:
return := GetValueAt(Range, 2, 1);Result:
| B |