Excel HLOOKUP Function

Use:
Uses a specified key to return a value from a row of a horizontally organized table
Syntax:
HLOOKUP( key , table , row )
Examples:
Cell C11 formula:   HLOOKUP( B11 , C2:H7 , 3 ) determines the cost to send a 13.7 pound package by courier

Cell D11 formula:   HLOOKUP( B11 , C2:H7 , 5 ) determines the lowest cost to send a 13.7 pound package

Cell E11 formula:   HLOOKUP( B11 , C2:H7 , 6 ) determines the lowest cost mode to send a 13.7 pound package

Note:
The top row of the horizontal table must be the key comparison row. It must be sorted in ascending order.

It is often handy to specify the table by an absolute address ($C$2:$H$7) instead of a simple relative address (C2:H7). This greatly simplifies copying vlookup formulas to other cells in your spreadsheet.

Related Function:
VLOOKUP and MATCH