Think HR Think CHRM
Monday - 29 May 2017

CHRMGlobal.com on LinkedIn
Username : Password: Forgot Password?
Updates
Updates
V-look up and H-look up?
Human Resources » Technology


Chrm Message From: rajul Total Posts: 45 Join Date: 10/11/2006
Rank: Executive Post Date: 07/01/2016 09:31:18 Points: 225 Location: United States

Dear colleagues,

I want to learn using these functions and will appreciate if some of you can provide simple steps in understanding and practising the function.

When to use v and h look ups, for what purpose specifically and formulas that are frequently to be used?

Thanks in advance for help.

Regards,

Rajul 

Chrm Message From: tiwarirekha Total Posts: 18 Join Date: 10/11/2006  
Rank: Executive Post Date: 07/01/2016 09:34:20 Points: 90 Location: United States

Dear Rajul,

Unsure if you have taken the effort to browse the internet because there are loads of relevant links on this subject.

https://kb.wisc.edu/page.php?id=1237

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm#step2

http://www.ehow.com/how_5161695_use-vlookup-amp-hlookup-excel.html

See what suits you best.

Rekha 

 
Events
 
Related Discussion
Shake it Off and Step Up
Setting up of an HR Dept.
Never Give Up
Exit Interviews - Ask & F
Setting up a Performance
Teaming Up
Sign-up Bonus
Setting up a behavioural
Manpower planning process
Reg : Salary break up
 
Related Articles
Keeping morale up in the