Change discription in header after changing in drop down menu value.

[needhelp2]

Hi Dear All,

I need little assistance regarding "Change discription in header after changing in drop down menu value"
e.g

{=IF(C5:C75="tub_doors","Select Color","Products")}
i am putting above array formula in header.

i want that when ever in c column tub door select from drop down that it write select color in header other wise product.

is it possible,can any body assist me to do so..

Thanks in advance.


its only working in c5, not in other cells after this,