vlookup formula

SYNTAX: =VLOOKUP(search_key, range, index, [is_sorted ])

search_key - The value to search for. For example, '42', 'Cats' or 'I24'.

range - The range to consider for the search. The first column in the range is searched for the key specified in 'search_key'.

index - The column index of the value to be returned, where the first column in 'range' is numbered 1.

is_sorted - [optional] - Indicates whether the column to be searched (the first column of the specified range) is sorted, in which case the closest match for 'search_key' will be returned.