Index Match issue

[yoan6]

On the code below, I try to put the value of Correspondance1 into the Match formula but it doesn't work.

Do you have an idea why it doesn't work?

Name1 = Sheets("SLA").Cells(Step1_Row, Step1_Clm).Value

Correspondance1 = Application.WorksheetFunction.VLookup(Name1, Sheets("Correspondance").Range("A2:B172"), 2, False)

cl.FormulaArray = _
        "=IF(ISNA(INDEX(Log_WK!C[-5],MATCH(SLA!RC[-4],,0))),"""",INDEX(Log_WK!C[-5],MATCH(SLA!RC[-4],IF(" & Correspondance1 & "=Log_WK!C[-3],Log_WK!C[-2]),0)))"

 

[Special-K99]

How does it "not work"?

 

[yoan6]

For example, when I got the value "Update Marley" for Correspondance1 the result is empty but if I forced the value like below I have the good result.

cl.FormulaArray = _
       "=IF(ISNA(INDEX(Log_WK!C[-5],MATCH(SLA!RC[-4],IF(""Update Marley""=Log_WK!C[-3],Log_WK!C[-2]),0))),"""",INDEX(Log_WK!C[-5],MATCH(SLA!RC[-4],IF(""Update Marley""=Log_WK!C[-3],Log_WK!C[-2]),0)))"

</pre>