Definition:
The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.
Syntax:
VLOOKUP(value, table, index_number, [approximate_match])
Parameters or Arguments:
Value: The value to search for in the first column of the table.
Table: Two or more columns of data that is sorted in ascending order.
Index_number: The column number in table from which the matching value must be returned.
Approximate_match(optional): Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, then default will be taken as TRUE.
Approximate_match(optional): Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, then default will be taken as TRUE.
How to use the VLOOKUP Function:
The VLOOKUP function is actually quite easy to use once you understand how it works.
Lets go for an example
Figure: VLOOKUP Function
VLOOKUP function mainly works on given ID that searches the value from which the column number and given ID are intersecting together.
Notes:
