Vlookup function is used for searching a value in the left most column of a table and then returns a value in the same row from a column you specify.
The syntax is : = VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
1 Lookup_value is the value to search in the first column of the table array
2. Table_array is two or more columns of data. Use a reference to a range or a range name
3. Col_index_num is the column number in table_array from which the matching value must be returned.
4.Range_lookup is logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match
If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
The values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value.
If FALSE, VLOOKUP will only find an exact match. In this case, the values in the first column of table_array do not need to be sorted. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.
If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
The values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value.
If FALSE, VLOOKUP will only find an exact match. In this case, the values in the first column of table_array do not need to be sorted. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.
No comments:
Post a Comment