Drawing Log Problem Using Offset And Match Functions

I am a new user and would appreciate some help with the following issue.

Currently I am building a drawing log for my company that tracks new incoming drawings. Down the first column are listed the drawing titles and across the top are the titles of the changes. Therefore when a new drawing comes in I insert the title across the top and with an "X" the corresponding drawing title (See Attached Document)

My issue is with the "Latest" column. I want to scan each row for the last "X" and return the corresponding change title. Currently I am using the following formula which works for about 80% of the rows:

=OFFSET(C3,-(ROW(C3)-1),MATCH("x",D3:BW3))

Is there an easier and better way to do this? Thank you in advance for your help.