Forum Discussion
hai_ng0212
Oct 17, 2021Copper Contributor
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
4 Replies
Sort By
The formula in AF3 cannot refer to AF3, that causes a circular reference. What exactly do you want to do?
- hai_ng0212Copper Contributor
Hello Hans, the formular wasnt at "AF3" it is at AF176.
Basically i want to return the header if anything in that row = "( )"