Over thinking an Excel problem

[bdg724]

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 1500 people which is why I need this formula.

Thanks!

[bebo021999]

Try:
=IFERROR(INDEX($A$1:$E$1,,LOOKUP("completed",OFFSET($A$1:$E$1,MATCH(J2,$A$2:$A$4,0),),{1,2,3,4})),"")

[bdg724]

Perfect! Thanks so much for the quick help!

[mcmahobt]

If Quang's solution isn't what you're after, could you provide more information? Where are you looking to see this data, on Sheet2 that you currently have setup? Or on the Summary sheet? If the latter is correct, we need sample data that shows how your Step 1-4 data is setup within Restaurant List.