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 );
A reference to a CXlOper that will contain the requested data if the macro succeeds.
Value to be found in the first row of the table.
Table of information in which data is looked up.
Row number in table_array from which the matching value will be returned.
Whether to allow an inexact match.
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.