Is it possible to display column headings in a cell based on content of other cells

Hi, I've googled but can't find a solution.

Is there a formula to display all the column headings for the cells that contain the text "IN"?

Basically, it's a holiday calendar with the staff names down the side and dates as column headings.

So I need a column showing a summary cell for each person. It needs to display the dates that they are "IN" like this: Mon 19/7, Tue 20/7, Fri 23/7.

Some of the cells say IN, the rest are just shaded with no data. Hopefully this makes sense.

Thanks in advance.

Is there only going to be one matching "IN" date for each person?

If so,

Then say your list is in A1:E4 with names in A2:A4 and dates in B1:E1

then if you list the names in F1:F3, use formula in G1:

=INDEX($B$1:$D$1,MATCH("IN",INDEX($B$2:$D$4,MATCH(F1,$A$2:$A$4,0),0),1))

copied down. Adjust ranges to suit.,

Format these cells as dates.

Not sure if that helped or not... but in case you (or future users) need to have multiple dates pulled for any user...

With same setup as above (table in A1:E4) and names listed in F1:F3, then in G1:

Please Login or Register  to view this content.

adjust ranges and confirm with CTRL+SHIFT+ENTER not just ENTER and copy down and across as many columns as you need to ensure all dates pulled.

Then to hide 0's, select the range of results and format as m/d/yyyy;;;

or any date format followed by 3 semicolons.