What is VLOOKUP function?
*A function that searches for a specific value in the first column of a table and returns a value in the same row from a specified column.* It is a function of Ms Excel to find out given value or data from another lot of data , which allows searches across columns.
# It can type as =VLOOKUP or +VLOOKUP
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Lookup_value: This is the value you want to look up in the table.
Table_array: This is the range of cells that contains the data you want to search through. The lookup_value should be found in the first column of this range.
Col_index_num: This is the column number from which you want to retrieve the result. It's a relative value, where 1 refers to the first column in the table_array, 2 to the second column, and so on.
[range_lookup] (optional): This argument specifies whether you want an exact match (FALSE or 0) or an approximate match (TRUE or 1). If omitted, Excel assumes an approximate match by default. For most cases, you should use FALSE (0) for an exact match.
Here's a step-by-step guide on how to use VLOOKUP:
Assume you have a table of data like this:
A B
Item Price
Apple Rs.1.00
Banana Rs.0.75
Orange Rs.1.25
Grape Rs.1.50
You want to find the price of an "Orange" (lookup_value) using VLOOKUP.
In an empty cell, type the following formula:
=VLOOKUP("Orange", A2:B5, 2, FALSE)
"Orange" is the value you're looking for.
A2:B5 is the table_array that contains the data.
2 is the column number (column B) from which you want to retrieve the price.
FALSE specifies an exact match.
Press Enter.
Excel will search for "Orange" in the first column of the table_array and return the corresponding price of Rs.1.25 in the cell where you entered the formula.
Put Comment for quarry