How to use Vlookup in excel with example?

VLOOKUP is a function of excel to lookup and access data from a specific column in Excel table or Excel Range. The “V” stands for “vertical” so we can say it vertical Lookup.

Types of Matching Data

VLOOKUP access data from two method.

(A) Approximate Match
(B) Exact Match

(A) Approximate Match  –  We have to mention TRUE or 1 in a syntax arguments.

(B) Exact Match We have to mention FALSE or 0 in a syntax arguments.

 

Note – If we don’t mention False or 0 for Exact Matching then Data must be in ascending order.

Partial Match

Vlookup supports wildcards (* ?) for partial matches. We use (*) to represent any series of character and (?) to represent any single character.

Rules

(A) The position of Lookup values must be in the first column of the table or range

(B) Lookup columns must be right positions.

Note

When the lookup values is duplicate then Vlookup access the upper value from table or range.

The syntax of Vlookup is

=VLOOKUP(lookup_value, table_array,col_index_num,[range_lookup)

Lookup_value        The value to look for in the first column of a table or range

Table_Array           The table from which to access a value.

Col_Index_Num    It is column index number, which is starts from left

[Range_Lookup]    [Optional] TRUE or 1 = Approximate Match. FALSE or 0 = Exact Match.

Here you can download excel for practice

In this workbook 10 example including with interview question of Vlookup which is most usable in excel .

  1. Simple Vlookup
  2. Vlookup Array
  3. Vlookup with Column Function
  4. Vlookup with match Function
  5. Vlookup with Large Function
  6. Vlookup with If and Choose Function
  7. Vlookup with choose function
  8. Vlookup with Date Function
  9. Vlookup with text function
  10. Interview Question

Download Workbook

How to use Vlookup in excel with example?

How to use Sumif and Sumifs Function in Excel?

Leave a Reply

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