mouucolours.star
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
nashbramhall
1624

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
Found at Excel: vlookup on pivot table, vlookup, pivot table
Found at Google
Have a nice day.
Simhan
A retired academic in the UK

From United Kingdom
sandeeptodi
1

Excel itself has very good help on this. Vlookup and Hlookup are essentially way 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. E.g., if you want to find out if 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 does a search across columns instead of rows.
See the attached xls for an example of vlookup.
Email: Sandeep.todi at emportant.com

From India, Pune
Attached Files (Download Requires Membership)
File Type: xls vlookup example.xls (23.0 KB, 2400 views)

sriiir
3

as said you can refer to help in excel, for further more information refer to the site Tech on the Net this provides information about all the formula used in excel.
From Canada, Montreal
amit0104
6

Please find the same..... Regards, Amit
From India, Ghaziabad
Attached Files (Download Requires Membership)
File Type: xls vlookup&hlookup.xls (53.0 KB, 2150 views)

rupesh.raj89
Hi,i want to know how to use Hlookup so pls suggest me with a example of any attach files Regards Rupesh kumar
From India, Gurgaon
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.