Dear all, can anyone help me to have deep knowledge about pivot table and v-look up,as it is very essential for HR.
From India, Jaipur
Acknowledge(0)
Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
The best way to learn is to search the web. For example, I found this on VLOOKUP:
[Excel: VLOOKUP on Pivot Table, VLOOKUP, Pivot Table](http://en.allexperts.com/q/Excel-1059/2008/4/vlookup-pivot-table.htm#b)
Found at [Excel: VLOOKUP on Pivot Table, VLOOKUP, Pivot Table](http://en.allexperts.com/q/Excel-1059/2008/4/vlookup-pivot-table.htm#b)
Found at [Google](http://www.google.co.uk/#hl=en&source=hp&q=pivot+table+and +vlookup&aq=f&aqi=g1&aql=& amp;amp;oq=&gs_rfai=&fp=560307af1b 915219)
Have a nice day.
Simhan
A retired academic in the UK
From United Kingdom
Acknowledge(0)Amend(0)
1639[Excel: VLOOKUP on Pivot Table, VLOOKUP, Pivot Table](http://en.allexperts.com/q/Excel-1059/2008/4/vlookup-pivot-table.htm#b)
Found at [Excel: VLOOKUP on Pivot Table, VLOOKUP, Pivot Table](http://en.allexperts.com/q/Excel-1059/2008/4/vlookup-pivot-table.htm#b)
Found at [Google](http://www.google.co.uk/#hl=en&source=hp&q=pivot+table+and +vlookup&aq=f&aqi=g1&aql=& amp;amp;oq=&gs_rfai=&fp=560307af1b 915219)
Have a nice day.
Simhan
A retired academic in the UK
From United Kingdom
Acknowledge(0)Amend(0)
Excel itself has very good help on this. VLOOKUP and HLOOKUP are essentially ways to reference a value from a table. This reference can be used to manipulate the lookup value instead of copy/pasting it in multiple places, hence the single source can be referenced in other sheets easily.
It is also very useful to find out if data exists in the reference table. For example, if you want to determine if the Revised salary is updated for all employees in the Increment sheet, you can easily do it through VLOOKUP. If the value is not found, you'll see "N/A" in the lookup value.
HLOOKUP is also very useful; it performs a search across columns instead of rows.
Please refer to the attached XLS for an example of VLOOKUP.
Email: Sandeep.todi at emportant.com
From India, Pune
Acknowledge(0)Amend(0)
It is also very useful to find out if data exists in the reference table. For example, if you want to determine if the Revised salary is updated for all employees in the Increment sheet, you can easily do it through VLOOKUP. If the value is not found, you'll see "N/A" in the lookup value.
HLOOKUP is also very useful; it performs a search across columns instead of rows.
Please refer to the attached XLS for an example of VLOOKUP.
Email: Sandeep.todi at emportant.com
From India, Pune
Acknowledge(0)Amend(0)
As mentioned, you can refer to help in Excel. For further information, please visit the site Tech on the Net. This website provides information about all the formulas used in Excel.
From Canada, Montreal
Acknowledge(0)Amend(0)
From Canada, Montreal
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.