Learn More About Vlookup & Hlookup In Excel.. CiteHR

SUNNY KUMAR VAISH Started The Discussion:

Sir, I want to learn more about VLOOK UP & HLOOK UP IN EXCEL. Please help me to understand better use of its. Thanks Sunny Kumar

sudhirchand -  Member Since: Sep 2009
Dear Sunny,

Basically if you want to learn Vloop and Hloop then you need to take guidance through any knowledgeable person on the system. In the written you can not learn to use formulaes in MS-Excel. Still I would like to tell you the use of Vloop and Hloop.
Vloop is used to get any data on any sheet from the relevant things. For that we need to excel sheets. One is database and another is the excel sheet on the you are using vlookup or hlookup.

I hope it will help you out but still I will prefer you to learn on the system through any knowledgeable person.


ajayaatreyasa -  Member Since: Sep 2009
Not this section to be answered, mods please move this to knowledge or resource center section.

kamleshsujal09 -  Member Since: Aug 2009
Dear Sunny,

For VLOOKUP You should have data in Excel file there is at least 1 coloumn is common in both sheets.
1- you select the common coloumn and put ,
2- then select the common coloumn sheet from other file and with clickshift and go upto those coloumn where you want to pull data and drag it up to ladt row of this sheet.
3- then put ,
4- put no. of coloumn
5- then put ,
6- false
7- press enter tab.

I hope it will be in order



nitluck -  Member Since: Jun 2008
Dear Senior

I need your help regarding paid Leave record, basically I need leave record format, Hear is leave paid and there are 1500 employee in my organization , kindly provide me suitable format for leave so that I can maintain 1500 employee’s records. You can mail me on


  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.
  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:

    3M Users, 100K+ Documents & 450K+ Discussions
    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network