# hlookup: Hlookup Spreadsheet Function for an Array

> hlookup (Hlookup Spreadsheet Function for an Array) is a 1001fx API function in the group Spreadsheet: POST https://api.1001fx.com/spreadsheet/hlookup, 2 credits per call. It works as a ready-made module in Make and n8n or as a plain HTTP call.

Implements a hlookup function similar to the GSheet and Excel functions. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.

- Group: Spreadsheet
- Endpoint: `POST https://api.1001fx.com/spreadsheet/hlookup`
- Authentication: header `X-API-KEY: YOURSECRETAPIKEY`
- Content type: application/json
- Credits: 2 credits per call
- Ready-made in: Make and n8n
- Docs: https://1001fx.com/functions/hlookup

## Parameters

- `data` (array<object>, required) – Data: Array of lines with mixed values.
- `lookUpValue` (string, required) – Lookup value: The value to be found in the specified row of the data.
- `row` (number, required, min 0) – Row: The row to look up.
- `ignoreCase` (boolean, optional, default `true`) – Ignore case sensitivity: Sets case sensitivity for lookup operation.

## Example: Look up, ignoring case

```bash
curl -X POST 'https://api.1001fx.com/spreadsheet/hlookup' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"data":[{"Alice":1,"Bob":2,"Charly":3,"Dave":4},{"Alice":"Germany","Bob":"USA","Charly":"Austria","Dave":"Switzerland"},{"Alice":11,"Bob":12,"Charly":13,"Dave":14},{"Alice":"Apple","Bob":"Banana","Charly":"Cherry","Dave":"Dragonfruit"}],"lookUpValue":"Alice","row":2,"ignoreCase":true}'
```

Answer (HTTP 200):

```json
{
  "result": "Germany"
}
```
