Vlookup - interview question Doc Download.. CiteHR

hiteshtkr_hr@yahoo.co.in Started The Discussion:

Dear Seniors, Please post some information about vlookup and logical formulas(please post example if possible). Regards, Hitesh

Rashid Ahmed -  Member Since: Apr 2009
Dear Hitesh,

I am attaching some details about Vlookup function.

Following links will help you to learn more functions and other options in MS Excel.



Hope useful for you.



Attached FilesProvided by community member Rashid Ahmed. Join us to learn and grow with your peers.
File Type: doc VLOOKUP.doc (293.0 KB, 778 views)
priya.jammu -  Member Since: Oct 2007
Hi Hitesh,

Use F1 in Excel and learn more. Every function in Lookup & References are explained neatly with examples in Excel 2007. I'm attaching a sample tried by me. It was actually an interview question asked by a HR Manager to me.

What function will you use to extract Blood group of an employee from Master file to another file by comparing EMP ID of both file? VLOOKUP

Try some more samples... Good luck...

Attached FilesProvided by community member priya.jammu. Join us to learn and grow with your peers.
File Type: xls VLOOKUP.xls (19.5 KB, 617 views)
gnshj.gnshj@gmail.com -  Member Since: Nov 2011
Interview Question

Basic question you ask to them this is first thing to learning for interview questions .

For Exmp :


what is you good Name

What is ur family background.?
What is ur qualification ..?

tell me about ur self ?

what u know about Hr .?
what is ur specification in Hr ?



  • 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