How to retrieve TEXT value from the top row of a marked column

[pharrell]

Using this grid, how may I retrieve the TEXT value "Sprint 00" from the top row of the column marked with "X"? I'd like to retrieve the TEXT value of "Sprint 00" into the first "???" row under the "Sprint" column. Subsequently, I'd like to retrieve the TEXT value "Sprint 01" from the top row of the second column marked with "X". I'd like to retrieve the TEXT value of "Sprint 01" into the second "???" row under the "Sprint" column. Can't quite seem to make VLOOKUP, HLOOKUP, INDEX, or MATCH work for me here. Thanks for the help![TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Sprint[/TD]
[TD]Sprint 00[/TD]
[TD]Sprint 01[/TD]
[TD]Sprint 02[/TD]
[TD]Sprint 03[/TD]
[/TR]
[TR]
[TD]???[/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]???[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Using this grid, how may I retrieve the TEXT value "Sprint 00" from the top row of the column marked with "X"? I'd like to retrieve the TEXT value of "Sprint 00" into the first "???" row under the "Sprint" column. Subsequently, I'd like to retrieve the TEXT value "Sprint 01" from the top row of the second column marked with "X". I'd like to retrieve the TEXT value of "Sprint 01" into the second "???" row under the "Sprint" column. Can't quite seem to make VLOOKUP, HLOOKUP, INDEX, or MATCH work for me here. Thanks for the help!
...

A2, copied down:

=LOOKUP(9.99999999999999E+307,1/(B2:D2="X"),$B$1:$D$1)