Hi guys,
Needing some help with creating the functions for this google sheets below.
docs.google.com
Basically, I would like to be able to select from the drop down the place that the student got for each event on the year groups pages, and then have it automatically fill in the score on the results pages using the numbers on the param page. Is this possible? I am still very new to sheets and excel.
TIA
Kristen x
Needing some help with creating the functions for this google sheets below.
Champion Boy and Girl Year 3-6
Param First,20,points Second,15,points Third,10,points Fourth,5,points
Basically, I would like to be able to select from the drop down the place that the student got for each event on the year groups pages, and then have it automatically fill in the score on the results pages using the numbers on the param page. Is this possible? I am still very new to sheets and excel.
TIA
Kristen x
