How to use the Excel VLOOKUP function

How to use VLOOKUP function

VLOOKUP function (MS EXCEL)

What is VLOOKUP?

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (*?) for partial matches. The "V" stands for "vertical" , Lookup values must appear in the first column of the table, with lookup columns to the right.

Lookup a value in a table by matching on the first column.

Syntax
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Example.

Do the following steps

1st Step
Enter your Data in EXCEL WORKSHEET.
Example.

2nd Step

Enter VLOOKUP function

Press enter.

And if you want to DRAG this function. Then you can do.

But if you have error like that

For Example.

THIS IS THE PROBLEM OF TABLE ARRAY

YOU CAN FIX THE TABLE ARRAY 

YOU CAN ALSO DRAG THIS FORMULA.