ISNA + Vlookup function not working but vlookup function works before

I set different variable and want to run a formula as follows, however I can run it in excel but cannot run it in vba, attached is for reference. Please notice that all variable are set correctly because i can run a vlookup formula before, but I can't run it after I added if isna function.

    For iStyleD = lrStyleD To 1 Step -1
            If Range(ColLstatus & iStyleD).Value2 = "" Then
                Range(ColLstatus & iStyleD).Value2 = "=IF(ISNA(VLOOKUP(" & ColLstatus & iStyleD & ",'C:\Excel\halo\[abc.xlsx]Details'!R6C4:R210C5,1,FALSE)), ""NO"", ""YES"")"
            End If
    Next iStyleD