Module: Editor
Version: 2.2.1 +
Description
The formula 'FindNextRow' gets the row number of a specified value or the row number of the value that comes next to the specified value. As result the row number that contains the Lookup_value or the value that comes next to the Lookup_value is returned. The Lookup_value can be a date, a real number or an integer. The formula 'FindNextRow' searches into the first column of a table to find the Lookup_value. 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 is bigger than the biggest value in the table, the result will be -1. For this formula the values in the first column need to be ordered from small to big.
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 'FindNextRow' works.
Values parameters
Table:
| Column 1 | Column 2 |
|---|
| 2 |
6 |
| 4 |
-7 |
| 6 |
8 |
| 8 |
-9 |
| 10 |
10 |
Lookup_value:
5
Result
Result:
2
The result is row 2, because 6 comes next to the Lookup_value 5. So the formula returns the row with value 6.