Think HR Think CHRM
Tuesday - 14 Jul 2020

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: 52 Join Date: 10/11/2006
Rank: Manager Post Date: 07/01/2016 09:31:18 Points: 260 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: 24 Join Date: 10/11/2006  
Rank: Executive Post Date: 07/01/2016 09:34:20 Points: 120 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