Index Match return "0" or NA

Occasional Contributor

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

hai_ng0212_0-1634490895539.png

 

4 Replies

@hai_ng0212 

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

@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 = "(    )" 

@hai_ng0212 

Sorry. Try

 

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

THANKS ... it worked