Stopping duplication of a INDEX formula

Hello,

So I am trying to generate a rota. I am using the INDEX formula to randomly take people from a list in Column AF and place them into columns B to E

Column I to J represents everyone on leave

My question is how can I stop duplicate values showing up within the same row. I have attached the excel sheet for clarification.

Thanks