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.
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...
Why Vote? User validation is extremely important for good content to prosper.