Looks in the first column of an array and returns the value of the indicated cell
static int VLookup( CXlOper& xloValue, const CXlOper& lookup_value, const CXlOper& table_array, unsigned long col_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 column of the table.
Table of information in which data is looked up.
Column 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.