How to use the Excel VLOOKUP function

Vlookup excel function is an inbuilt referencing function which is used to find out a certain data from a group of data or range which is also known as table array, vlookup function uses total of four arguments, the first argument is the reference cell and the second argument is the table array, the third argument is the column number where our data is and fourth the matching criteria.

Syntax: =VLOOKUP (value, table, col_index, [range_lookup])

The VLOOKUP function syntax has the following arguments:

  • value – The value to look for in the first column of a table.
  • table – The table from which to retrieve a value.
  • col_index – The column in the table from which to retrieve a value.
  • range_lookup – [optional] TRUE = approximate match (default). FALSE = exact match.

Example: Let’s look at some Excel VLOOKUP function examples and explore how to use the VLOOKUP function as a worksheet function in Microsoft Excel:

Excel VLOOKUP function - How to use the Excel VLOOKUP function

1. Syntax:  =VLOOKUP(I15,H8:K13,4,FALSE)

Result:

Excel VLOOKUP function 1 - How to use the Excel VLOOKUP function

Based on the Excel spreadsheet above, the following VLOOKUP examples would return:

Syntax ID: 32
Result: 91685

Syntax ID: 100
Result: 32192

Syntax ID: 16
Result: 96115

2. Syntax: =VLOOKUP(I15,H8:K13,3,FALSE)

Result:

Excel VLOOKUP function 2 - How to use the Excel VLOOKUP function

Syntax ID: 10
Result: Mackenzie

Syntax ID: 100
Result: Melanie

Syntax ID: 16
Result: Aubree

3. Syntax: =VLOOKUP(I15,H8:K13,3,TRUE)

Result:

Excel VLOOKUP function 3 - How to use the Excel VLOOKUP function

Syntax ID: 124
Result: Mackenzie

Syntax ID: 126
Result: Aubree

Add a Comment

Your email address will not be published. Required fields are marked *