• Futurama Formulas - Date and time
• Futurama Formulas - Math
• Futurama Formulas - Statistical
• Futurama Formulas - Text
• Futurama Formulas - Logical
• Futurama Formulas - Table
• Futurama Formulas - Document
• Futurama Formulas - Conversion
• Futurama Formulas - Matrix
• Creating custom formulas in Futurama

Module: Editor

Version: 2.2.1 +

Type: Long/Double

Category: Table

## 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.

Table:

Column 1Column 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.

## Related Topics

FindRow: The formula 'FindRow' returns the row number of a reference. This refererence can be a text, a date, a real number or an integer.

FindPreviousRow: The formula 'FindPreviousRow' gets the row number of a specified value or the row number of the value that is previous to the specified value.