# HLOOKUP Function

This article explains how to use the HLOOKUP function

FS`HLOOKUP (value, datasheet, row_index, [range_lookup])`

`value`

- The value to look for in the first row of a datasheet.

`datasheet`

- The table from which to retrieve a value.

`row_index`

- The row in the datasheet from which to retrieve a value.

`range_lookup`

- [optional] 0 = exact match (default). 1 = approximate match.

`range_lookup_higher_bound`

- [optional] 0 = return lower value (default). 1 = return higher value

# Sample Usage

Lookup the exact value of `Question A`

in row 1 of `Datasheet A`

and retrieve the value from the 2nd row (row numbering starts at 0 - zero):

FS`HLOOKUP(QA, DA, 1, 1)`

**OR**

Lookup the value `180`

in row 1 of `Datasheet B`

and retrieve the value from the 3rd row:

FS`HLOOKUP(180, DB, 2, 2)`

# Example calculator

# Notes

- Instead of a table range in a spreadsheet program (e.g.
`A1:B22`

), the value of the datasheet needs to be just the reference to that datasheet (eg.`formulascript>DA`

). - Instead of working with the native datasheet for tables you can also work with data from a Google Sheet. See this article to learn more.
- Row numbering in a datasheet starts at 0. So if you need to retrieve a value in the 3rd row of your datasheet, you should reference this row in your formula with a 2.