Returns the relative position of an item in an array that matches a specified value in a specified order
static int Match( unsigned short& uspos, const CXlOper& lookup_value, const CXlOper& lookup_array, unsigned short match_type = 1 ); static int Match( unsigned long& ulpos, const CXlOper& lookup_value, const CXlOper& lookup_array, unsigned short match_type = 1 ); |
A reference to a value that will contain the requested data if the macro succeeds. It will contain zero if no value matches the lookup_value.
Value to be found in the first column of the table.
Table of information in which data is looked up.
Match type.
A reference to a value that will contain the requested data if the macro succeeds. It will contain zero if no value matches the lookup_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.
See the Microsoft Excel on-line Help for full details about this function.
Header: xlfuncs.h