Hi everyone. I am working on a formula for the a tracker that I use (see screenshot). Here is the formula.

=IFNA(IFNA(INDEX(MMP[Grant Date],MATCH($D8&" "&$T$2,MMP[ID],0)),INDEX(No_Progress[IFNA for MMP],MATCH($D8&" "&$T$2,No_Progress[ID],0))),"NEED TO ASSIGN")

I need the formula to give a "not required" value if the data in column C contains the number a 5-9.

I think adding this formula will work.

IF(OR(COUNTIF($C8,"*5*"),COUNTIF($C8,"*6*"),COUNTIF($C8,"*7*")) and so on.

Is there a better way maybe as a range? The formula will get too long for my taste this way.

I'm open to power query options as well. Most of my work is based on index/match formulas and basic power query.

Thanks for the help.

Brandon