Thanks to the new dynamic array functions, these types of expressions are much easier to create and maintain. You enter the function as you normally would—with a simple Enter, and the results ...

Value: Explanation: 0: Find an exact match; return #N/A if none found. This is the argument’s default value.-1: Find an exact match; return the next smaller item if no match is found.