formulas

  • Thread starter Thread starter tk
  • Start date Start date
T

tk

Hello

I have just finished creating a spreadsheet for a school for sportsday
but on the events sheet.
For example the 100 metre race where it shows the students that came
first second and third I have used cell refrencing that worked but i
want a more reliable formula that will find the student ID, name,
surname, etc. I have tried using vlookup, but that never really
worked.
Any suggestions would be greatly appreciated.
To see it go to the below address
http://spreadsheets.google.com/pub?key=pfd4W8ZzrMZYGKS3UELtgSA&gid=2
 
For VLOOKUP, what is the "lookup" field you use? ID appears to be the likely
candidate.

What formulae have you tried?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Combining rows 4
Combining Rows on a label 1
Dates into percentages 21
Count words in spreadsheets 2
Filling Formulas 2
Access linking new student form to new course form 2
register student to course 0

Back
Top