VLOOKUP in Excel 2007

This is one of the most powerful functions available in MS Excel 2007. This is a great tutorial. Additionally you can do similar stuff Hlookup().

Good luck and happy hunting / spreadsheet-ing.