Formula that shows text of header in cell for process status

[sirenetta1]

Can you help me?

My header row contains titles for steps in a process:

A1: Step 1
B1: Name
C1: Step 2
D1: Title
E1: Step 3
F1: Step 4
G1: Process Status

Under those columns, I'm putting text when something is done.

What formula could I use in column G to show where I am in the process?

For example:
See G2 below...
Because I did not get to Step 2, it just displays "Step 1" in G2.

A1: Step 1
A2: 4/2/05
B1: Name
B2: Bob
C1: Step 2
D1: Title
E1: Step 3
F1: Step 4
G1: Process Status
G2: Step 1

Thanks!!!

BTW: I have up to 10 steps in this process... [/img]

 

[barry houdini]

So, I'm assuming that you only want to show one of the "Steps", not "Name" or "Title" or "Process Status". Try

=LOOKUP(2,1/((A2:F2<>"")*(LEFT(A$1:F$1,4)="step")),A$1:F$1)

 

[sirenetta1]

Yes, the Process Status column would only have "Step 1" "Step 2" etc. depending on what was the last step that was complete. Thanks for your formula! I'll see what it can do!