lookup last cell with certain text and give heading of this cell

Hi all,
I would appreciate help from anybody,
for me huge problem, hopefully with simple solution.
I have table of data for differnt types of absence... in first column are names of different people (so each person has one row of table) and then i have kind of calendar table where each column is one day of the month.. i need to search for S (for sick) and S1/2 (for half day sickness) for each person in whole month and to give me date of last sickness.

I hope its clear enough to understand what i need. Thanx for help.

It's not clear at this stage if you have other text strings within the table that are to be ignored and, if you do, whether or not they begin with S

In theory - if you don't have other strings then:

Please Login or Register  to view this content.

where C2:AG2 holds days info for ee and row 1 the associated dates

If you do have other strings to worry about (but not with S) then you might try:

Please Login or Register  to view this content.

If in doubt, post a sample file.

An addition to DonkeyOtes' second formula seems to work

In AM5

Please Login or Register  to view this content.

I have also simplified your header formulae.