advanced excel seminar training - Formulas and V Looks ups

Hi Emma

Vlookup is a function in excel that allows you to find relevant information based on a search criteria. Usuially it is used in lists, were you are looking for a code and then returning a specific value in a separate column.

As an example, you might have a list of employees, who have an emploee code. Lets say the other infiormation in the list was things like name, address, phone and salary.

Vlookup would be used to find an employee code, and then return their salary, for instance.


Regarding formulas, and which one to use, it really depends on what you are trying to do. There are hundreds of functions in Excel, and they are divided into catagories, like TEXT, DATA, MATHS, STATISTICS, SCIENTIFIC, etc. The best place to find out more about this is to go to the menu bar and clieck on INSERT > Function. This will give you a list of all the functions, plus a description of what the function does, and the various syntax of the formula.

regards

richard