How do I assign lockers to students using Excel? I have their ID#s and I have the locker numbers.?

I want to randomly assign the locker numbers to student ID#s. HELP!!
Update: I know how to put them in columns (Locker # and ID#) but how can Excel "randomize" the assignment of these lockers to the students?
2 answers 2