Bug in the formula MATCH
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
veb86 · 2025-02-07 06:28

Match typeBehaviorDetails1ApproximateMATCH finds the largest value
less than or equal to the lookup value. The lookup array must be
sorted in ascending order.0ExactMATCH finds the first value equal to
the lookup value. The lookup array does not need to be
sorted.-1ApproximateMATCH finds the smallest value greater than or
equal to the lookup value. The lookup array must be sorted in
descending order.(omitted)ApproximateWhen match_type is omitted, it
defaults to 1 with behavior as explained above.
The type - 0 is not working correctly. It shows the last result of the
entry, but it should be the first one.

----------------------------------------------------------------------
wp · 2025-02-08 11:02

Fixed in r9621