XLL+ Class Library

CXlFuncs::VLookup

Looks in the first column of an array and returns the value of the indicated cell

[C++]
static int VLookup(
   CXlOper& xloValue,
   const CXlOper& lookup_value,
   const CXlOper& table_array,
   unsigned short col_index_num,
   bool range_lookup = true
);

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.

table_array

Table of information in which data is looked up.

col_index_num

Column number in table_array from which the matching value will be returned.

range_lookup

Whether to allow an inexact match.

Return value

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.

Remarks

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

Requirements

Header: xlfuncs.h

See Also

CXlFuncs Class | CXlFuncs Methods