Match with <>

[HESH]

Can we use the function MATCH with signs of comparison, for example
=match(>=10,a1:a20,0)

 

[Haseeb Avarakkan]

Try,

=MATCH(TRUE,(A1:A20>=10),0)

Confirmed with Ctrl+Shift+Enter, not just Enter.

 

[HESH]

thank you haseeb
Does this mean we can not use of signs of compare in this function at Lookup_Value

 

[Aladin Akyurek]

thank you haseeb
Does this mean we can not use of signs of compare in this function at Lookup_Value

A few functions would understand such an expression. MATCH is not one of them.

 

[HESH]

A few functions would understand such an expression. MATCH is not one of them.

thank you sir