AnsweredAssumed Answered

Nexel Formula - MATCH/INDEX

Question asked by fabio.giordano on Nov 13, 2019
Latest reply on Nov 18, 2019 by fabio.giordano

Hi Everyone,


i'm trying to replicate in Nexel the following excel formula:




The objective is to obtain the row number of a range where a condition is met for the first time.
In the example attached i'm looking to find in the range (B2:B6) the first row where the value is ">1000" (A2), so the 4th.


I can't find the right syntax and unfortunately the "Nexel formulae" doesn't help.

I'm working with Board version 10.1.2

Thank you,