I think I am overthinking this and am fighting a migraine today. Please help. I have a summary worksheet that I want to use to display the current status of a project I am working on. That data is on a separate worksheet. I have four stages to display. On the summary tab I want the corresponding stage I am working on to reflect on that page. Hopefully I can explain in a way that makes sense. I have four people. They each have to go through four stages of an interview process. Once they complete each stage I put complete in the corresponding column. I want the summary page to look at those columns and see what stage they are in. Can I do this? I've attached the basic sheet. I actually have 500 people which is why I need this formula.

Thanks!