Excel

Hi Claire,

Thank you for your question.

You use Vlookup to retrieve data from a spreadsheet which is arranged in columns.

=vlookup(Lookup value,table array,Column Index Number, Range Lookup)

The vlookup is the data entry point for your search and must be the value contained in the first column of your Excel list. The Table Array is the range of cells that makes up your list, Columns Index number represents the column number for which the data is to be retrieved from and the Range Lookup is whether you want an exact match or closest match.

To create a pivot table go to Data and then the pivot table option. Select the range of cells you ae trying to analyse the data from, then go to Layout and choose a Page field followed by row and column headings. Where the row and column headings meet or intersect, you assign a data field.

I hope this answers your questions.

Regards

Simon