Find cell "X" and return Header

[Pestomania]

I am trying to identify whenever a column has an "X" in it. I have this formula which returns the first column with a "number". I tried using ISTEXT("X") and the Match("X") formulas but all are returning the incorrect column for cell = "X".

Can you please see what I might be doing wrong:

This one provides the correct column name, if there is any number value.

=INDEX($AU$3:$GT$3,AGGREGATE(15,6,(COLUMN(AU5:GT5)-COLUMN(AU5)+1)/(ISNUMBER(AU5:GT5)*(AU5:GT5>0)),1))

This returns the correct column if cell <>"0".

=INDEX($AU$3:$GT$3,AGGREGATE(15,6,(COLUMN(AU5:GT5)-COLUMN(AU5)+1)/(ISTEXT("X")*(AU5:GT5>0)),1))

But I need it to return the column for the cell that equals "X"/.

 

[Fluff]

How about

=INDEX($AU$3:$GT$3,AGGREGATE(15,6,(COLUMN(AU5:GT5)-COLUMN(AU5)+1)/(AU5:GT5="X"),1))

 

[Fluff]

Another option as you have 365 is

=take(filter($AU$3:$GT$3,AU5:GT5="X"),,1)

 

[Pestomania]

Another option as you have 365 is

=take(filter($AU$3:$GT$3,AU5:GT5="X"),,1)

You are awesome!!

Thanks for the quick response too. I guess I was making it more difficult then it needed to be.

 

[Fluff]

You're welcome & thanks for the feedback.