How to do VLOOKUP in Microsoft Excel

Excel vlookup tutorial : VLOOKUP is a function in Excel that perform a vertical lookup by searching for a value in the first column of a table and returning for a value in the same row in the index number position. VLOOKUP is simple, yet confusing for many. Here, we have tried to explain this function with help of very simple example.