Stringfunctions+ | Formula LOOKUPEXCEL
Description
This formula looks up values in an Excel file and inserts them into a results column.
Formula(s)
PHP
{=LOOKUPEXCEL("File ID";"Column";"Value";"Column for result";"Tab name")}Result
Array
Parameters
Parameter | Content | Format | Default value | Explanation |
|---|---|---|---|---|
File ID | File to be looked up | String Integer |
| |
Column | Name of the column to be looked up | String |
| |
Value | Value to be looked up | String |
| |
Column for result | Column in which the value is to be written if the value is found | String |
| |
Tab name | Worksheet for the result (optional) | String | "" |