vlookup - Vlookup Spreadsheet Function for Arrays
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.
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 first column of the data
Example:
Applecolumnnumber
The column to look up
Example:
2ignoreCaseboolean
Sets case sensitivity for lookup operation
Example:
Available on
