What is the difference between VLOOKUP, pivot table and Concatenate?
What is the difference between VLOOKUP, pivot table and Concatenate?
Rajesh Pathak
Vlookup: Vlookup is an excel function that extracts data from the right column. To extract data from the left column, you use the combination of INDEX & MATCH functions.
Pivot table: Pivot table helps to summarize and analyze the data. It also does the calculations for you.
Concatenate: Concatenate is an excel function to merge two strings together. For example, ‘Rajesh’ and ‘Pathak’ are in cell A1 and cell A2 respectively. You can use concatenate function to make it ‘Rajesh Pathak’ in cell A3.