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
Bookmarks