Return header of a specific cell

[sthomay]

I am trying to combine multiple projects into 1 dashboard. In the dashboard, I want to find the matching feature on one program's grid, go find the last cell in that row with text, and return the header of that column.


I have been able to make this formula work if the features are always in the same order:
INDIRECT(LEFT(CELL("address",OFFSET($B6,0,COUNTA(B6:E6)-1)),2)&"$5") -- found in cell C13

But I can't figure out how to first find the matching feature, then go find the last cell in the row with text, then return the header. The cells in yellow are what I am trying to solve for.

Sample data attached

[Glenn Kennedy]

Please tell us the EXPECTED answers... a non-working formula is of very little use!!

[Glenn Kennedy]

A guess, despite the confusion caused by the so-called result for feature 1, produced by the wonky formula:

=IFERROR(INDEX($5:$5,AGGREGATE(14,6,COLUMN($C$5:$F$5)/(INDEX($C$6:$F$8,MATCH(B13,$B$6:$B$8,0),)>0),1)),"Not started yet")

[sthomay]

This worked great thank you!
And sorry about the missing information!

[Glenn Kennedy]

Woo Hoo! The crystal ball was working well today!

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.