[Excel] Text Search with VLOOKUP

Syntax VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) lookup_value is the value to find in the first column of the array. The lookup_value argument can be a value, a reference, or a text string. table_array is the data table in which the value is searched for. Use a reference to a range or a range name, such as Database or List. If the range_lookup argument is TRUE, the values in the first column of the table_array argument must be in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE. Otherwise, the VLOOKUP function may return an incorrect value. If the range_lookup argument is FALSE, the items in the table do not need to be sorted. You can sort the values in ascending order by choosing the Sort command in the Data menu and selecting the Ascending option. The values in the first column of the table_array argument can be text, numbers, or logical values. The function is not case-sensitive. col_index_num is the number of the column in the table_array argument from which the corresponding value should be returned. If the col_index_num argument is equal to 1, the function returns the value in the first column of the table_array argument; if the col_index_num argument is equal to 2, the value is returned from the second column of the table_array argument, and so on. If the col_index_num argument is less than 1, the VLOOKUP function returns the error value #VALUE!, and if the col_index_num argument is greater than the number of columns in the table_array argument, the VLOOKUP function returns the error value #REF!. range_lookup is a logical value that indicates whether you want the VLOOKUP function to find an exact match or an approximate match for the value you specified. If this argument is TRUE or omitted, an approximate match is returned. In other words, if no exact value is found, the next largest value that is less than lookup_value is returned. If range_lookup is FALSE, the VLOOKUP function returns an exact match. If no match is found, the error value #N/A is returned.