# HLOOKUP

## Content

This function searches for a value in the top row and then returns a value in the same column from a specified row.

## Syntax

`HLOOKUP(value, array, row, [approx])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *value* | \[Required\] \[Required\] Value to be found in the first row |
| *array* | [Required] Array or range that contains the data to search |
| *row* | [Required] Row number in the array from which the matching value will be returned |
| *approx* | [Optional] Logical value indicating whether to find an approximate match; if omitted, uses TRUE and finds an approximate match |

## Remarks

If *approx* is FALSE, it finds an exact match, not an approximate match. If it cannot find one, it returns an #N/A error value.
If *approx* is TRUE or omitted, and the *value* cannot be found, then the largest value that is less than the *value* is used.
This function is similar to VLOOKUP except that it searches by row (horizontally), instead of vertically (by column).

## Examples

`HLOOKUP("Test",A1:D5,3,TRUE)`