Hello Dear Freinds, can anybody explain me in details regarding Vlookup, Hlookup, Pivot table with suitable illustration. As now a days this are the necessacity of an organisation. It would be great help if anybody provide me suitable examples and also let me know in which version of excel it is usefull. Thanks in advance.