Skip to content
# What is VLOOKUP in Excel?

#### VLOOKUP STARTER

#### How to Write Excel VLOOKUP Formula?

**Still Need Help in VLOOKUP Parameters: ** See below picture. Hope this helps 😊

That’s how you can use VLOOKUP for standardizing big databases and linking the different excel files.

###### Points To Remember

## Similar Posts

### EXCEL FUNCTION – ISERROR

### EXCEL FUNCTION – COUNTA

### EXCEL FUNCTION – AVERAGEIFS

### EXCEL FUNCTION – SUBSTITUTE

### EXCEL FUNCTION – NOW

### EXCEL FUNCTION – ISBLANK

## One Comment

### Leave a Reply Cancel reply

Anyone who wants to get expertise in Excel, **VLOOKUP** is an essential function for those which can easily make you awesome in excel.

There are two kind of lookups in excel one is **VLOOKUP** and second is **HLOOKUP**. Both works on same methodology with small difference that **VLOOKUP** works vertically (in Columns) and **HLOOKUP** works horizontally (in Rows). That’s why these are called Vertical Lookups and Horizontal Lookups respectively.

**VLOOKUP**. There are many ways to use **VLOOKUP** which we will discuss with different methods and examples. Please follow our blog to become an expert of **VLOOKUP**

**VLOOKUP** is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string. Below is an image to explain you the same.

**VLOOKUP** Function for patient name mentioned in **Cell H6**

Excel Formulas
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

Now while looking at above Formula, there are four parameters which are described as below:

**lookup_value:**this is a matching value which we will find in our database to locate the position and get respective values from different columns from the same position**table_array:**this is our database where we will find our matching value and get the respective left most column value**col_index_num:**this is a column position or column address from where we need the value depending on the matched string of different column**[range_lookup]:**here will be instructing the excel whether to find approximate match for the given lookup value or to find exact match

So here we have an example in Cell H6 “Martha Achock” and will get the Patient ID, Date of Birth, Site in H7,H8,H9 respectively. Below are the formulas which we need to write for getting these values:

**Cell H7: “=VLOOKUP($H$6,$A$1:$E$17,2,0)”**

**Cell H8: “=VLOOKUP($H$6,$A$1:$E$17,3,0)”**

**Cell H9:** **“=VLOOKUP($H$6,$A$1:$E$17,4,0)”**

This will get the respective VLOOKUP value for given Lookup value from the table_array.

- VLOOKUP finds the value in the left most column only
- Col_Index_Num is the position from where we want to extract the value
- Use Absolute range while copying or filling down the same formula from one cell to another cell
- [range_lookup): False or 0 is commonly used for the 4th Parameter in Vlookup. It helps to find exact match

**Subscribe Our Blog to get more updates on Vlookup trick in Excel.**

Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any Error or not....

COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2

AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

SUBSTITUTE function is used to substitute the existing old text to new text.

Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.

Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any...

Really this is very nice article…and this is easy to understand..