Need to call up header names into one field for all cells which have a value from a row

I've got a spreadsheet made up that I'm trying to make much more user friendly. I've been on this forum for the last month or so getting great help but I can't seem to find a thread that can help me with my problem.

The table has employee names down the first column (about 250) the remaining columns indicate training each worker has received (First aid, fall arrest...B-AD). Rather than scan the whole table for a name then scroll across to find that worker's training I want to be able to enter the workers name (currently using a data validation drop down but I'm up for a better option), then the next cell over would populate with the header title of any cell in that row with a value in it. I'm at a loss for how to phrase the function. I've tried using lookups but I can only get the results of one cell. I imagine it will be a long string of IFcell(NOTBLANK(THEN "title")) but it's the formatting that's getting me

From there I want to elaborate on valid and expired certification but I think with nesting current formatting arguments i can get that on my own once i have a bit of direction with the first issue.

Thanks to both of you. I got an answer just after leaving work and as I don't have a copy of the file at home haven't been able to check it until just now. I think I'm going to use the second option only because it is more similar to what i normally do and can alter it as needed easier.

I'm not sure if this falls within the rules as it is a clarification on the formula not a separate question. Martin, with the formula for "the last bit" I'm having problems when a worker has tickets for multiple equipment (eg. fork lift and man lift). it seems the formula, which returns the value to the left of the found "-". however if there are multiple "-" found then it uses the average of the search table (eg. if fork lift is row 1 and man lift is row 5 the response is row 3). Besides splitting the column into 5 separate columns is there a solution.

the only solution I could find was doing left then a right search but then i came across an entry with three in it so that made it the wrong solution. I've tried a few google searches to try and pull info out but they all pertain to single strings within a cell. I think I'm just going to have to bite the bullet and expand the table some more. I've attached the formula as it sits now. I've had to break it in half at First aid, it was coming back as too many arguments.