Return Column Header of Last Occurence of Specified Value

  • I have various values that repeat in columns BHS:BWT, I would like a formula that identifies the last column a specific value (this value is in BWU) occurs in a row and return the column header to column BWW.

    For example: in row 2, BWU=4, "4" is in columns BHS:BIM, the column header of BIM is 290, I would like 290 be returned as the value in BWW.