Looks up a value either from a one-row or one-column range or from an array. Provided for backwards compatibility.
| Name | Type | Description |
| arg1 | any | Is a value that LOOKUP searches for in Lookup_vector and can be a number, text, a logical value, or a name or reference to a value. |
| arg2 | ApiRange | Is a range that contains only one row or one column of text, numbers, or logical values, placed in ascending order. |
| arg3 | ApiRange | Is a range that contains only one row or column, the same size as Lookup_vector. |