is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE (or zero) if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message:
是可选的参数，用于指示数组中的第一列是否按照升序排序。如果第一列未按升序排列，请输入逻辑值 FALSE 或 0。已排序的列查找比较快并且函数有返回值，即使没有精确地找到要搜索的数值，但只要这个数值介于排序列表的最小值和最大值之间，函数就能够返回一个数值。在未排序列表中，查找的数值必须精确匹配。否则，函数会返回错误信息：