Retrieving Header of last not empty cell using unique identified?

%3CLINGO-SUB%20id%3D%22lingo-sub-1579085%22%20slang%3D%22en-US%22%3ERetrieving%20Header%20of%20last%20not%20empty%20cell%20using%20unique%20identified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579085%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20Excel%20to%20return%20the%20row%20header%20of%20the%20last%20populated%20(not%20empty)%20cell%20in%20a%20row%20associated%20with%20a%20given%20unique%20value.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3A%20The%20status%20cell%20should%20reflect%20%22Routing%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22384%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3EID%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EDesc%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EDrafted%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EReady%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ERouting%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EApproved%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3ERST%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EXYZ%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3CTD%3EYes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EID%3C%2FTD%3E%3CTD%3EStatus%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%3F%3F%3F%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1579085%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1579134%22%20slang%3D%22en-US%22%3ERe%3A%20Retrieving%20Header%20of%20last%20not%20empty%20cell%20using%20unique%20identified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755067%22%20target%3D%22_blank%22%3E%40_aeung%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DINDEX(1%3A1%2CMATCH(REPT(%22z%22%2C255)%2CINDEX(1%3A1048576%2CMATCH(B7%2CA%3AA%2C0)%2C0)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1579355%22%20slang%3D%22en-US%22%3ERe%3A%20Retrieving%20Header%20of%20last%20not%20empty%20cell%20using%20unique%20identified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579355%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 DescDraftedReady Routing Approved
1ABCYesYesYes 
2RSTYesYes  
3XYZYesYesYesYes
      
 IDStatus   
 1???   
2 Replies
Highlighted

@_aeung 

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

Highlighted