# HLOOKUP

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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* | Value to be found in the first row |
| *array* | Array or range that contains the data to search |
| *row* | 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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionVLOOKUP) except that it searches by row (horizontally), instead of vertically (by column).

## Data Types

Accepts numeric or string data. Returns numeric data.

## Examples

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

## Version Available

This function is available in product version 2.0 or later.

## See Also

[VLOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionVLOOKUP) \| [LOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOOKUP) \| [Lookup Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functslookup)