In Excel,there is a function named as xlookup and it has the following syntax with $6$ parameters and the last three are optional.

$=$XLOOKUP$($lookup$\_$value, lookup$\_$array, return$\_$array, $[$if$\_$not$\_$found$],[$match$\_$mode$],[$search$\_$mode$])$

The search mode can refer to $1)$ search from the first item to the last item in the lookup$\_$array, $2)$ search from the last item to the first item in the lookup$\_$array, or $3)$ binary search. For binary search, sorting the lookup$\_$array is optional.

True

False