If an exact match is not found, the next largest value that is less than lookup_value is returned. If Range_lookup is True or omitted, an exact or approximate match is returned. If Col_index_num is greater than the number of columns in table_array, the VLookup method generates an error. If Col_index_num is less than 1, the VLookup method generates an error. Use the VLookup method instead of the HLookup method when your comparison values are located in a column to the left of the data that you want to find. Range_lookup - a logical value that specifies whether you want the VLookup method to find an exact match or an approximate match. A col_index_num of 1 returns the value in the first column in table_array a col_index_num of 2 returns the value in the second column in table_array, and so on. Uppercase and lowercase text are equivalent.Ĭol_index_num - the column number in table_array from which the matching value must be returned. These values can be text, numbers, or logical values. The values in the first column of table_array are the values searched by lookup_value. Use a reference to a range or a range name. Table_array - two or more columns of data. If lookup_value is smaller than the smallest value in the first column of table_array, VLookup returns the #N/A error value. Lookup_value can be a value or a reference. Lookup_value - the value to search in the first column of the table array. VLookup ( Arg1, Arg2, Arg3, Arg4)Įxpression A variable that represents a WorksheetFunction object. Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |