MicrosoftAs for the binary search principle of the MATCH, VLOOKUP, and LOOKUP functions, I agree with you. However, I have one question. And I think there is no answer other than the logic I have uncovered. Binary search reduces the number of searches by moving in opposite directions to the large and small search values in random cells about half of the range to be searched. However, when finding the last data, the 1 option of MATCH specifies a value greater than the range, and the -1 option specifies 0 if the value in the range is not negative, and the last value is found.
However, in the data of #NA, #NA, #NA, 1, #NA, 1, when 2 is the search value, the first 1 should be found in the binary search logic, but Excel returns the last 1. So the logic I came up with is that even if it is a binary search, when you search from the very end and then try the binary search. This has nothing to do with whether the cells are aligned or not.
What do you think about this?
