If Formula Begins With

[tcnt9176]

Can anyone tell me why the result is always false even when it should be true? It works if I change it to exact but begins with does not work.

    Range("B2").FormulaR1C1 = _
        "=IF(RC[6]=""FromRAM*"",VLOOKUP(C[-1],'[Bump Information.xls]CQS Assignments'!C1:C2,2,FALSE),false)"

 

[schielrn]

You cannot write an IF formula like that. You would need to do:

Range("B2").FormulaR1C1 = _
        "=IF(left(RC[6],7)=""FromRAM"",VLOOKUP(C[-1],'[Bump Information.xls]CQS Assignments'!C1:C2,2,FALSE),false)"

Hope that helps.

 

[p45cal]

try

    Range("B2").FormulaR1C1 = "=IF(LEFT(RC[6],7)=""FromRAM"",VLOOKUP(C[-1],'[Bump Information.xls]CQS Assignments'!C1:C2,2,FALSE),FALSE)"

or even

    Range("B2").FormulaR1C1 =  "=IF(LEFT(RC[6],7)=""FromRAM"",VLOOKUP([B]RC[-1][/B],'[Bump Information.xls]CQS  Assignments'!C1:C2,2,FALSE),FALSE)"

 

[tcnt9176]

Thanks!! That worked perfectly!!!