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 |
"" |
|