hlookup - Hlookup Spreadsheet Function for an Array
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.
dataarray
Array of lines with mixed values.
Minimum: 1
Example:
[
{
"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"
}
]lookUpValuestring
The value to be found in the specified row of the data.
Example:
Alicerownumber
The row to look up.
Example:
2ignoreCaseboolean
Sets case sensitivity for lookup operation.
Example:
Available on
