Dear Seniors, Please post some information about vlookup and logical formulas(please post example if possible). Regards, Hitesh
From India, Ahmadabad
Acknowledge(0)
Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
Dear Hitesh,
I am attaching some details about the Vlookup function. The following links will help you to learn more functions and other options in MS Excel:
- https://www.citehr.com/183149-ms-excel-manuals.html
- https://www.citehr.com/104727-excel-...ictionary.html
Hope this is useful for you.
Regards,
Rashid
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
78I am attaching some details about the Vlookup function. The following links will help you to learn more functions and other options in MS Excel:
- https://www.citehr.com/183149-ms-excel-manuals.html
- https://www.citehr.com/104727-excel-...ictionary.html
Hope this is useful for you.
Regards,
Rashid
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
Hi Hitesh,
Use F1 in Excel to learn more. Every function in Lookup & References is explained neatly with examples in Excel 2007. I'm attaching a sample I tried. It was actually an interview question asked by an HR Manager.
What function will you use to extract the Blood group of an employee from the Master file to another file by comparing the EMP ID of both files? VLOOKUP.
Try some more samples... Good luck...
From India, Bangalore
Acknowledge(1)Amend(0)
Use F1 in Excel to learn more. Every function in Lookup & References is explained neatly with examples in Excel 2007. I'm attaching a sample I tried. It was actually an interview question asked by an HR Manager.
What function will you use to extract the Blood group of an employee from the Master file to another file by comparing the EMP ID of both files? VLOOKUP.
Try some more samples... Good luck...
From India, Bangalore
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Interview questions.doc