No Tags Found!

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)

Understanding VLOOKUP and HLOOKUP in Excel

Excel itself provides excellent 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 copying and pasting it in multiple places, allowing the single source to 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.

Regards,
[Email Removed For Privacy Reasons]

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

Acknowledge(0)
Amend(0)

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

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.