The problem I am encountering is I simply do not know how to do what I am wanting. (If im going to be honest, I barely figured out how to do what i have thus far)
I have a "staffing Guide" worksheet with various positions in several different locations (same worksheet, not necessarily contiguous cells)
On a separate worksheet, I have a list formulated based on three criteria, with information in three columns. This information is subject to change almost daily.
My goal is to randomly fill the positions on the "staffing Guide" sheet with employees from this list so long as they have not already been previously assigned to a position(meaning on a regular basis), and without duplicating the remaining unassigned names in the unfilled positions. I need to be able to also make some positions closed or unschedulable.

I have attempted to upload the workbook, but it fails each time. I am happy to send it if anyone is interested! ANY HELP would be MUCH APPRECIATED!!

I have attached pics of the respective sheets and below is what I have so far in terms of the formula to complete the task but am stuck at the spot where it needs to choose a random name that has not already been used.

=IF($A$3<>"","",IF(COUNTIF('DO NOT DELETE!!'!$Y$11:$Y$131,INFORMATION!$C2)>0,INDEX('DO NOT DELETE!!'!$W$11:$Y$1010,MATCH(INFORMATION!$C2,'DO NOT DELETE!!'!$Y$11:$Y$1010,0),1),IF(COUNTIF('DO NOT DELETE!!'!$Y$11:$Y$131,INFORMATION!$C2)=0,"NOT ASSINGED","HOLD PLEASE, STILL WRITING FORMULA")))

(I enter this as an array formula as well <ctrl+shift+ent>)

empl ifo.jpglist of employyes who can work by date.jpgstaffing guide.jpg