Return column title if value present

Right, apologies, I have let my excel skills suffer through lack of use. This hsould be easy.

ROW 1 - list of headings
ROW 2 - blank cells that may contain an "X"

At the end of Row 2 I want it to find out which is the last column with an "X" in it, i.e. F2, and return the title of that column, i.e. F1.

Any ideas?

You don't specify columns in play but let's assume A:Z

=INDEX($A$1:$Z$1,MATCH(REPT("Z",255),$A2:$Z2))

=index(b1:m1,1,match("*",b2:m2,-1))

Not quite sure I follow the AAA/BBB requirement... if we say it should contain AAA then I would probably opt for something like:

=LOOKUP(2,1/(ISNUMBER(SEARCH("AAA",$A$1:$Z$1))*ISERR(SEARCH("BBB",$A$1:$Z$1))*($A2:$Z2="X")),$A$1:$Z$1)

[deleted - misread]

In hindsight my prior post might have been right after all... given AAA is seemingly a pre-requisite why not just test for that and ignore BBB altogether, ie:

Please Login or Register  to view this content.

My point is/was:

AAA = Valid
AAABBB = Valid
BBB = Not Valid

The common truth is that AAA must appear in the string, BBB is irrelevant.... or are you saying there are a plethora of other values other than AAA that are valid, eg CCC, DDD, DDE, DDEAAA etc... but BBB is only valid if with AAA, ie BBBCCC not valid etc.. ?

OK, slightly annoyed at myself because I did this yesterday and then opted against posting it... perhaps:

Please Login or Register  to view this content.