what is the difference between pivot table and vlookup?
Vlookup - Function used to find out a value in a range of data in the same worksheet or an external worksheet. Pivot Table: Used to represent bulk data in a more user friendly manner. Information can be portrayed in more vividly with the help of charts, slicers, tables etc.