Using VLookup for loop data from sheet to sheet

Let's say that you want to look up an employee's name, by using their ID number. You look up data to quickly and efficiently find specific data in a list and to automatically verify that you are using correct data. After you look up the data, you can perform calculations or display results with the values returned. There are several ways to look up values in a list of data and to display the results.

1. Open excel that you want to loop data from sheet to sheet. On picture below we have two sheet in one file
    - One : Name
    - Two : ID


2. Type Vlookup on column that you want to vlookup from name sheet to ID sheet

     =Vlookup(select value that you want to match, Other sheet,column index,true/false)