Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
▪ lookup_value: is the value to be found in the first column of the table, and can be a value, a reference, or a text string.
▪ table_array: is a table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name.
▪ col_index_num: is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1.
▪ range_lookup: is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE.
No comments:
Post a Comment