VLOOKUP

A look at how to create formulas in Excel 2007. Save time and create powerful equations.

Use the COUNT function - count how many numbers, words or specified words are in a selection

Apply a name to a range of cells

Use the IF function - A test which checks whether a certain condition is true or false, and will display a...

Apply a name to a range of cells which span multiple sheets

Manage the names you've applied to cell ranges

Using named ranges in formulas

View named ranges easily

Easily watch selected cells no matter what you're currently looking at