Looks up values in a vector or array
[C++]
static int Lookup(
CXlOper& xloValue,
const CXlOper& lookup_value,
const CXlOper& array
);
static int Lookup(
CXlOper& xloValue,
const CXlOper& lookup_value,
const CXlOper& lookup_vector,
const CXlOper& result_vector
);
A reference to a CXlOper that will contain the requested data if the macro succeeds.
Value to be found in the first column of the table.
Range or array to be searched for lookup_value.
1-dimensional range or array to be searched for lookup_value.
1-dimensional range or array containing results.
Zero if the function has been called successfully; non-zero
if the function could not be called.
See Error codes for a list
of return values.
See the Microsoft Excel on-line Help for full details about
this function.
Header: xlfuncs.h