Hi.... I am new in excel and want help ...
please check the attached file....
i wand to checke C4 - AX4 if they contain "D", ... if it is true then return Header title and in this case C2 - AX2
any help ? thx

Well it's a lovely attached image. Just a pity it's too small to see properly.
Attach an Excel file and perhaps we can help you.