v look up , r look up, pivot table

This query is : Resolved

Share Report Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

16 July 2010 some body tell me that wt is the use of v look up, r look up and pivot table in exel it's urgent

CA. BIJENDER KR. BANSAL

CA. BIJENDER KR. BANSAL (Expert)
Follow

16 July 2010 VLOOK UP
This function scans down the row headings at the side of a table to find a specified item.When the item is found, it then scans across to pick a cell entry.

There is no R look up in excel

HLOOKUPThis function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry.

pivot table

biggest advantage to using Pivot Tables is the fact that we can generate and extract meaningful information from a large table of information within a matter of minutes. Or perhaps it is because they will not use up a lot of memory from your PC. In a lot of cases we could get the same results from a table of data by using Excels built in functions, but this would take more time and use far more memory. On top of this, if we wanted some new information we can simply drag-and-drop (pivot). We can also opt to have our information update each time we open the Workbook and/or by clicking refresh.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now