PrabasTech

Excel VLOOKUP Function

VLOOKUP FUNCTION

What is VLOOKUP function in Excel?

VLOOKUP function helps you to extract your desired value or data from a range, the range can also be a Excel table.

The structure of the VLOOKUP formula is as follows:

Return value
The matched value from a table.

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

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.

VLOOKUP is a very commonly used function in many industries for many purposes. Knowing this function will take you to the next level in you reporting / automation career.

Trust me, some of my friends got job just by knowing this function. 

This video tutorial explains the basics of VLOOKUP function and its arguments in a simplest manner. 

Download Excel

for Practice

Match and replace using VLOOKUP

This tutorial explain the way to match and replace a list of data using VLOOKUP function. 

We have explained some of the important items in this tutorial.

  1. Get / Replace Employee Names from Employee ID by lookup into an Employee data set
  2. Get / Replace Department Names from Department ID by lookup into to an Department data set
  3. Usage of F4 in any formulas to lock its movement – Relative and Absolute reference
  4. Using a proper Excel Tale in formulas for better enhancement

Download Excel

for Practice

VLOOKUP Exact Match vs. Approximate Match

This tutorial explain the key differences in the range_lookup argument in the VLOOKUP function. Note that this rane_lookup argument is the last argument and this is just an optional argument.

True = Approximate Match (default)

False = Exact Match

Knowing the differences between True & False will take you to the expert level in VLOOKUP function. 

Download Excel

for Practice

Want to receive weekly updates tips & tricks

then register here

Leave a Reply

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

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?