The main use of the vlookup in the Ms Excel is that if you want to find the hundred numbers from one sheet to another sheet. then it will take enormous time to find. If we use vlookup formula then it will instantly give you the results. Also we can find the duplicate numbers from one sheet to another instantly by applying the formula selecting the rows.