How to Use Vlookup in Excel

1. Open MS-Excel (Windows+R  enter Excel in run window)

2. Select the required data.

3. Here I want to check Products with Vlookup.

4. Enter Vlookup formula in B2 cell.

           

                    =Vlookup(

5. =Vlookup(lookup value,table array,column index,[range lookup]) It is the format of the formula.

          

                        Lookup_Value= It is value to be found in the first column of the table.

                        Table_array=  It describes the range of the data which you want to search.

                        Column_Index= Its Column number in Table_array from which matching value                                                              should be returned 

6. Here I want to search Product with product ID.

7. So selected the A2 (product ID) cell.

8. Selected the Range of data which is already have Product ID.

9. Select Column_Index Number from table_array.

10. Here i was choosen 2 column from table_array (Product)

11. Vlookup compares the lookup_value with table_array if Product ID matches in Table_array

it gives the Produt.

12.Mention 0 for exact match of result.

13.=VLOOKUP(A2,$E$3:$G$7,2,0)

*Here Dollar Symbol "$" indicates the exact area,the values between $E$ will remain same.