Hi,

Just looking into Lookups.

Can someone tell me the main use of this function.

I can find a value of product using find

Thanks

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.