Obtaining the column title for a specific cell

[rsizem]

The attached HTML file shows two charts.
The first chart shows that by using the "Max" function I can find the latest date of a status input.

The 2nd chart shows how I would like to end up. However, I can not find a formula, or set of logic statements to do this.

Is there a way that I can input the corresponding column Title into the next cell which is titled "Latest Status"

I am definitely stuck!!
Any inputs will be greatly appreciated.

Sample Header selection.xls
	B	C	D	E	F	G	H
1	LatestDateofStatus	LatestStatus	SubmissionReceived	SubmissionRejected	SubmissionFinancialsOK	SubmissionFinancialsRejected	SubmissionApproved
2	26-Mar-05	?????????	15-Nov-04	-	10-Jan-05		26-Mar-05
3	3-Feb-05	?????????	11-Jan-05	3-Feb-05
4	17-Feb-05	?????????	18-Jan-05	-	29-Jan-05	17-Feb-05
5
6	LatestDateofStatus	LatestStatus	SubmissionReceived	SubmissionRejected	SubmissionFinancialsOK	SubmissionFinancialsRejected	SubmissionApproved
7	26-Mar-05	SubmissionApproved	15-Nov-04	-	10-Jan-05	-	26-Mar-05
8	3-Feb-05	SubmissionRejected	11-Jan-05	3-Feb-05	-	-	-
9	17-Feb-05	SubmissionFinancialsRejected	18-Jan-05	-	29-Jan-05	17-Feb-05	-
Sheet2

 

[Andrew Poulsom]

Welcome to the Board.

In C2 enter:

=INDEX(D$1:H$1,1,MATCH(B2,D2:H2,FALSE))

and copy down.

 

[rsizem]

Outstanding >>7minutes & a two wk problem solved..

Thanks
What a welcome!