FINDROW() is a function that returns a rowlink, from a table or filter, based on a condition. The search is conducted sequentially, starting at the top, and returns the first matching row. If no matching row is found,
#N/A is returned.
Compare to the function VLOOKUP, here.
=FINDROW(table/filter formula, "condition", [condition_parameters])
- Table/filter: A table or filter that returns a list of rows.
Condition: This condition is applied to each row in sequence until it is evaluates
=TRUEand the matching row is returned. If this field is empty it evaluates
Condition parameter: Conditions can be parameterized like
A1 = %. In this case, “%” will be replaced by the values provided in the condition parameters before the condition is evaluated.
Returns the first task belonging to Adam, which is “Buy steaks"
|Was this article helpful?|