VLOOKUP - One of the Powerful Formula of Excel

 Hello Friends,

This is Amey Kulkarni from Amey Knowledge Hub.

In this Blog I will Explain How to use VLOOKUP Formula in Excel for you,  I have also made a video on the same. I will share the Link of the video and My Channel in last.

So Let's begin...

1st question comes in the Mind is what is VLOOKUP and Use of VLOOKUP. Ans to the same is very simple, VLOOKUP is a formula which can be used to extract particular data from Large number of details. It is used to find Vertical Look Up of data from Large number of Data which is provided.

Syntax (Formula ) for VLOOKUP is :

=VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUM,[RANGE_LOOKUP])

Here,

Lookup_Value : What you want to find

Table_Array : Where you want to find

Col_Index_Num : How Far is the Column from Lookup_Value

Range_Lookup : Define as Match of the Data

As explained below :