The formula =SORT (A3:B17) uses the default “sort by” and “sort order” settings; thus, the list is sorted in alphabetical order. The syntax for the new SORT function is =SORT (array, [sort_index], ...

Replace "I10" with the bottom cell from the array's last column. Identify the Column to Search Identify the column in the array that contains the data you want the Search function to find.