XLL+ Class Library (6.3)

CXlFuncs::HLookup

Looks in the top row of an array and returns the value of the indicated cell

static int HLookup(
   CXlOper& xloValue,
   const CXlOper& lookup_value,
   const CXlOper& table_array,
   unsigned long row_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 row of the table.

table_array

Table of information in which data is looked up.

row_index_num

Row 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