Index Match return "0" or NA

[hai_ng0212]

i have table want to use Index MAtch , but not sure what i am doing wrong here please help 

[#2]

@hai_ng0212 

The formula in AF3 cannot refer to AF3, that causes a circular reference. What exactly do you want to do?

[#3]

@Hans Vogelaar 

Hello Hans, the formular wasnt at "AF3" it is at AF176. 
Basically i want to return the header if anything in that row = "(    )" 

[#4 · Accepted solution]

@hai_ng0212 

Sorry. Try

=INDEX(B1:AB1,MATCH(AF3,B176:AB176,0))

[#5]

THANKS ... it worked