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 



4 Replies


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


Sorry. Try



THANKS ... it worked