Index/collect returning #no match when there is a match
I keep getting a #NO MATCH when clearly I can see the match. I have used index/collect nested in several IF functions with success, but I cannot see why I'm getting NO MATCH here/
=INDEX(COLLECT(ActualNAR:ActualNAR, Mth:Mth, 3, SCML:SCML, SCML@row), 0)
Help Article Resources
Check out the Formula Handbook template!