VLOOKUP • Vlookup is an advanced Excel function that helps extract values from the database.
• Vlookup can filter a large volume of data to provide the appropriate values based on the given conditions.
• V lookup can be used in two ways, to find an exact match and to find the closest match. In this example, it is used to find an exact match.
Excel VLOOKUP function is best suited for situations when you are looking for a matching data point in a column, and when the matching data point is found, you go to the right in that row and fetch a value from a cell which is a specified number of columns to the right.
Syntax
=VLOOKUP(lookup_value, table_array,
col_index_num,[range_lookup])
Input Arguments
lookup_value –
This is the look-up value you are trying to find in the left-most column of a table. It could be a value, a cell reference, or a text string.
table_array –
This is the table in which you are looking for the value.
This could be a reference to a range of cells or a named range.
col_index –
This is the column number from which you want to fetch the matching value.
[range_lookup] –
Here you specify whether you want an exact match or an approximate match.
TRUE or 1– approximate match
FALSE or 0– exact match
If omitted, it defaults to TRUE
0 Comments