Excel Help needed

[mctiny]

I have a multi-sheet work sheet with a totals sheet for my student/class records.

the spreadsheet has lists/coloums created with
Date¦Day¦from¦To¦Student¦Lesson¦Location¦Time¦Bus¦Total¦Rate¦Paid.

On the totals page I have lists of the students & days of the week.

What I owuld like to do is be able to have a reference for each item on the totals page so that I can enter "1" and dispaly "Monday", "2" = "Tuesday" and the same for students (different numbers of course).

Does anybody know if/how this can be done?

 

[MarcLister]

You could use VLOOKUP for this I think, if I understand what you want right.

http://www.google.co.uk/search?hl=en&safe=off&q=vlookup&btnG=Search

 

[mctiny]

You could use VLOOKUP for this I think, if I understand what you want right.

http://www.google.co.uk/search?hl=en&safe=off&q=vlookup&btnG=Search

doesn't appear to do the job.

on my "totals" sheet I have a reference table with days of the week and I'm looking for something that I can type a number which corresponds to a particular day.

Example 1=Monday, 2=Tuesday.

 

[MarcLister]

Where will you be writing the numbers? If you will always be writing the numbers in the same place then VLOOKUP will work.

 

[mctiny]

Where will you be writing the numbers? If you will always be writing the numbers in the same place then VLOOKUP will work.

In different cells within monthly sheets.

 

[MarcLister]

But they would be the same cells each time? You won't just pick random cells?

 

[mctiny]

But they would be the same cells each time? You won't just pick random cells?

the reference will the same cells each time but the location of inputted data will always change cells.

 

[MarcLister]

Can you send me an example of the spreadsheet so I can see what you would mean?