Forum Discussion

Cma103's avatar
Cma103
Copper Contributor
Mar 24, 2024

Formula for a table-- assigning names to numbers in multiple columns

Help! I have searched and tried multiple functions but cannot get the one I'm looking for. I am planning an elementary field day with 25 homerooms. Each homeroom has 18 students. Field day consists of 7 different events. The students in a homeroom are assigned to 4 of the 7 events, which means that 6 of the events will have 10 kids participating, and 1 event will have 12 kids participating. I went to a round robin generator to figure out which students should be randomly assigned to which events. The numbers in the Events table below correlates to the student number in the Student table. How can I get a formula so that it will populate the Events table based on the student's name that corresponds to the respective number? I want to be able to enter in each homeroom student list and let it fill in the Events table to print for the teacher. I have tried VLookup but I cannot get it to work on the entire table.

 

NumberStudent 
1Student A
2Student B
3Student C
4Student D
5Student E
6Student F
7Student G
8Student H
9Student I
10Student J
11Student K
12Student L
13Student M
14Student N
15Student O
16Student P
17Student Q
18Student R

 

 

Event 1Event 2Event 3Event 4Event 5Event 6Event 7
91514118812
101215913116
181351617910
117866165
131415314
816131210127
491817543
517271218
2610214713
141143181517
      16
      1
    • Cma103's avatar
      Cma103
      Copper Contributor

      Harun24HR I'm not sure if that's the function I'm looking for to replace the numbers with the names of students. Is there another one you might know? Thanks!

Resources