SOLVED

Index Match return "0" or NA

Copper 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?

@HansVogelaar 

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

best response confirmed by allyreckerman (Microsoft)
Solution

@hai_ng0212 

Sorry. Try

 

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

THANKS ... it worked
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@hai_ng0212 

Sorry. Try

 

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

View solution in original post