Searches across the first row of a range for a key and returns the value of a specified cell in the column found.
SYNTAX: =HLOOKUP(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 row in the range is searched for the key specified in 'search_key'.
index - The row index of the value to be returned, where the first row in 'range' is numbered 1.
is_sorted - [optional] - Indicates whether the row to be searched (the first row of the specified range) is sorted.
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice.