=HLookup( Lookup_Value, Table_Range, Row_Number, [Approx or Exact])
Lookup Value |
The value being looked-up. This can be a value, a cell reference, or text. |
Table Range |
Table that contains the look-up values. HLOOKUP always looks in the topmost row of the table The Table_Range can be an absolute cell reference or a named range. |
Row_Number | The row containing the value to be returned. This is the number of rows down in Table_Range . The result will be in this row in the same colimn where the |
Approx or Exact Match [OPTIONAL] |
If FALSE , an exact match must be found. If TRUE or blank, the closest match (less than the lookup_value) is selected. Data must be in order if FALSE is selected. |