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

Copper Contributor

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.


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
2 Replies
Did you try RANDBETWEEN() function?

@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!