What is vlookup and and pivot, table

Question

Accepted Answer

VLOOKUP is a function in Excel used to search for a value in a column and return a corresponding value from another column. Pivot tables are used to summarize and analyze data.

VLOOKUP is used to find specific data in a table based on a given value
It searches for the value in the leftmost column of the table
Once found, it returns a value from a specified column in the same row
Pivot tables are used to analyze and summarize large amounts of data
They allow you to group and filter data, calculate totals, and create visual representations

Accepted Answer

VLOOKUP is a function used in Excel when you are required to find things/values in data or range by row. This article looks at how to use VLOOKUP within the PivotTable.

Accepted Answer

Vlookup- Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

Pivot Table- A pivot table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values.

What is vlookup and and pivot, table

Top Grameen Foundation MIS Executive interview questions & answers

Popular interview questions of MIS Executive