Everybody has been so helpful here, I was hoping not to have to bother
everybody with another question, but it was not to be.

My problem now is that I have a list of all workers, now some maybe gone for
whatever reason, which would be another list. What I am trying to do is get
a list of available workers for that day, to hand out to the supervisor.

Workers:
Dave
Tom
Steve
Paul
Tim
Ben
Edward

Workers Not available that day:
Steve
Tim
Edward

Available Workers
Dave
Tom
Paul
Tim
Ben

Now I would like to be able do this in a formula. I have tried the match
function, also have tried using the if statement, but nothing is working.

Any help would be appreciated.