Issue with "Like" statements...

[BillTony]

I have a (long) formula that is functioning quite well.

However, I now need to be able to pick up any variations of "na" that I could potentially run across (NA, N/A, etc.).

In other words, I would like to basically pick up a wildcard value such as "n*".

I understand that "Like" is probably the way to go, but am having some difficulties with any forms that I have come up with so far...

Thanks in advance!

'Formula in column C - evaluating column B.
'However, there may be variations of "na."
    ActiveCell.FormulaR1C1 = _
        "=IF(RC[-1]=""na"","""",IF(RC[-1]="""","""",IF(AND(IF(ISNUMBER(FIND(""."",RC[-1])),LEN(RC[-1])-FIND(""."",RC[-1]),0)>=2,IF(ISNUMBER(FIND(""."",RC[-1])),LEN(RC[-1])-FIND(""."",RC[-1]),0)<=4),"""",""ERROR"")))"
'CONDITIONAL AutoFill based on last row in column A - 2 header rows.
    If Last_Row_ColA > 3 Then
        Selection.AutoFill Destination:=Range("C3:C" & Last_Row_ColA)
    End If

 

[cerfani]

You could "normalize" the value and by that I mean, to check if it is a variation of NA, then you should first lowercase the result and replace all non-alpha characters with empty characters "" and then just check if the value is "na"

 

[BillTony]

Thanks, this works!