Module: Editor
Version: 2.2.1 +
Description
The formula 'FindRow' returns the row number of a reference. This refererence can be a text, a date, a real number or an integer. The formula 'FindRow' searches into the first column of a table to find the Lookup_value . As result the row number of the reference is returned. Note, the function starts counting the rows with the number 0, so the first row is 0 second row is 1 etc. If the reference cannot be found in the table, the result will be -1.
Parameters
Table:
in this parameter you refer or fill in the table.
Lookup_value:
in this parameter you will fill in your lookup value.
Example
Description
In this example you can see how the formula 'FindRow' works.
Values parameters
Table:
| Column 1 | Column 2 |
|---|
| 1 |
6 |
| 2 |
-7 |
| 3 |
8 |
| 4 |
-9 |
| 5 |
10 |