Understanding VLOOKUP and Logical Formulas: Can You Share Examples and Tips?

Dear Seniors,

Please post some information about VLOOKUP and logical formulas (please provide examples if possible).

Regards,
Hitesh

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

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...