CXlFuncs::Lookup

Looks up values in a vector or array

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
);

Parameters

xloValue

A reference to a CXlOper that will contain the requested data if the macro succeeds.

lookup_value

Value to be found in the first column of the table.

array

Range or array to be searched for lookup_value.

lookup_vector

1-dimensional range or array to be searched for lookup_value.

result_vector

1-dimensional range or array containing results.

Return Value

Remarks

See the Microsoft Excel on-line Help for full details about this function.

Requirements

Header: xlfuncs.h

See Also

CXlFuncs Class | CXlFuncs Methods