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.
Vlookup supports wildcards (* ?) for partial matches. We use (*) to represent any series of character and (?) to represent any single character.
(A) The position of Lookup values must be in the first column of the table or range
(B) Lookup columns must be right positions.
When the lookup values is duplicate then Vlookup access the upper value from table or range.
The syntax of Vlookup is
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 .
- Simple Vlookup
- Vlookup Array
- Vlookup with Column Function
- Vlookup with match Function
- Vlookup with Large Function
- Vlookup with If and Choose Function
- Vlookup with choose function
- Vlookup with Date Function
- Vlookup with text function
- Interview Question