Forum Discussion

hai_ng0212's avatar
hai_ng0212
Copper Contributor
Oct 17, 2021
Solved

Index Match return "0" or NA

i have table want to use Index MAtch , but not sure what i am doing wrong here please help   
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Oct 17, 2021

    hai_ng0212 

    Sorry. Try

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Oct 17, 2021

hai_ng0212 

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

  • hai_ng0212's avatar
    hai_ng0212
    Copper Contributor
    Oct 17, 2021

    HansVogelaar 

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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 17, 2021

      hai_ng0212 

      Sorry. Try

       

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

      • hai_ng0212's avatar
        hai_ng0212
        Copper Contributor
        Oct 17, 2021
        THANKS ... it worked

Resources