I have a validated list that pulls resources from a tab named "staff." The same person is chosen from the drop down list under many weeks. I would like for the persons name to become blank in all of the cells where that person has been selected if I deleted the person from the available resources list on the "staff" tab. In the attached example, James Albritton is listed under week ending 5/4/12 as well as under week 5/11/12. He is listed under "staff" as an available resource. I would like to know how to make it so that if I delete him from the "staff" tab his name will appear as a blank in cells A4 & A84 automatically. example 1.xlsx