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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!