Search

 

Module: Editor

Version: 2.2.1 +

Type: Long/Double

Category: Table

 

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 1Column 2
1 6
2 -7
3 8
4 -9
5 10
Lookup_value:

4

Result

Result:

3

Related Topics

FindNextRow: 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.

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.

Updated: 2014-09-23