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:

 

=MATCH(TRUE;INDEX((B2:B8>A2);0);0)

 

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,

Fabio

Attachments

Outcomes