# vlookup: Vlookup Spreadsheet Function for Arrays

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

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

- Group: Spreadsheet
- Endpoint: `POST https://api.1001fx.com/spreadsheet/vlookup`
- 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/vlookup

## Parameters

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

## Use cases

- Look up a price or SKU in a product list without a spreadsheet
- Map country names to codes or customer IDs to account managers
- Enrich incoming orders with data from a reference table

## Example: Look up, ignoring case

```bash
curl -X POST 'https://api.1001fx.com/spreadsheet/vlookup' \
  -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":"Apple","column":2,"ignoreCase":true}'
```

Answer (HTTP 200):

```json
{
  "result": "Banana"
}
```

## FAQ

**How is the data structured?**

data is an array of rows, each row an object. The value is searched in the first column, and column selects the column of the result, counted from 1.

**Is the lookup case sensitive?**

Not by default: ignoreCase is true. Set it to false for an exact match.
