Assigning Cast Rolls In Excel

I do casting for a local Rocky Horror show, people sign up by putting down the roles they would be willing to play and my job is to make sure every role has a person and every person has a role. I have been doing this by hand by a couple of months in spreadsheets but I’ve started expanding my equation knowledge in excel and was wondering, is automating this possible?