Andreas Säger wrote:
If the scale is not in ascending order, the match point may not reflect better subsequent matches.
Like your example:
=INDEX({"Cat";"Dog";"Mouse"};MATCH( 3 ;{2;4;3})) => "Cat"
which is obviously wrong, but the lookup stops at the 4.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
