No Tags Found!

Dinesh Divekar

Business Mentor, Consultant And Trainer

Umakanthan53

Labour Law & Hr Consultant

Madhu.T.K

Seasoned Ir Professional

KK

KK!HR

Management Consultancy

Vmlakshminarayanan

Sr.manager - Hr&admin

Saswatabanerjee

Partner - Risk Management

Drsivaglobalhr

Doctor Siva Global Hr

Nanu1953

Ceo-usd Hr Solutions

AU

Aussiejohn

Workplace Assessment And Training

Rkn61

Sr. Hr Manager

NV

Nagarkar Vinayak L

Hr And Employee Relations Consultant

Alok-singh1

Labour Laws & Ir.

NA

Nathrao

Insolvency N Gst Professional

Kumaracme

Hr Manager, A Leading Manufacturing Company

Srivastavacmlal

Master Consultant

NK SUNDARAM

International Corporate Trainer / Hr (od) Consultant

Pan Singh Dangwal

Joint Manager

R.N.Khola

Labour Laws & Ir

Bijay_majumdar

Freelancer In Hr &indirect Taxes For Services Indusrty.

Jeevarathnam

Sr Manager Hr & Compliances

Pvenu1953@gmail.com

Retired Government Servant/advocate

Ommygautam

Plant Hr Head

GL

Glidor

Hr Consultant

Loginmiraclelogistics

Asso.prof.(commerce & Management)

Suresh2511

Labour Consultant

SU

Sudhapradheep

Sr. Executive-hr

Ram K Navaratna

Hr Consultancy

RE

Rei

Hr Executive

NK

Naresh Kumar Vadera

Retired Railway Servant

Dimcy-hasija

Hr And Administration Manager

BA

Babanguida

Hse Manager

DK

Deepa Kandu

Hr Professional

PK

Parrot King

Designer

PR

Prasanthnair

People Operations Manager

MS

Minu.Sharma

Manager Accounts

Kamesh93

Engineer

PD

Pardeep Dhiman

Safety Supervisor In Industrial Area.job In Mnc Company Gagret Himachal District Una Himachal Prades


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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Nashbramhall
Learning & Teaching Fellow (retired)
Mouucolours.star
Hr Executive
+4 Others

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, 2395 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, 2148 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
If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of our support system - Please Register and Log In to CiteHR.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server