Retrieving Header of last not empty cell using unique identified?

[_aeung]

I want Excel to return the row header of the last populated (not empty) cell in a row associated with a given unique value. Is this possible?

example: The status cell should reflect "Routing"

ID	Desc	Drafted	Ready	Routing	Approved
1	ABC	Yes	Yes	Yes
2	RST	Yes	Yes
3	XYZ	Yes	Yes	Yes	Yes
	ID	Status
	1	???

[#2]

@_aeung 

=INDEX(1:1,MATCH(REPT("z",255),INDEX(1:1048576,MATCH(B7,A:A,0),0)))

[#3]

Thank you @Hans Vogelaar !