Overview If you call MATCH arguments with lookupValue less then any possible in the range and use SMALLEST_GTE match type then MATCH will return N/A instead of the smallest number in the range. Steps to Reproduce 1) Create column with 3 cells: 3 2 1 2) In any other cell enter formula: =MATCH(0.9, A1:A3, -1) Actual Result The result will be N/A. Expected Result The result should be 3 Build Date & Hardware 2015 Sep 10 & Ubuntu 14.04.3 LTS
Created attachment 33089 [details] Patch for fixing bug with match function
Can you maybe also add a unit test to class TestMatch which ensures that this stays fixed in the future?
I've already added this to the patch file. This line in the TestMatch: confirmInt(5, invokeMatch(new NumberEval(3), ae, MATCH_SMALLEST_GTE));
Ah, sorry, I missed that. Applied via r1702535, thanks for the patch!