VBA FormulaARrray (Index w/ Multiple criteria)

[acerlaptop]

Hi,

I have a part here of my VBA code. I don't know what the problem is but the code returns a single result to all the covered ranges. It only returns the result for the first item.

For example:
In column F2 up to F10
All the results returned by the code from F2 to F10 is the result for F2.

Sheets(strN3).Range("F2:F" & LastRow2).FormulaArray = _
    "=INDEX(HELPER!C[-3],MATCH(1,(HELPER!C[-2]=RC[-3])*(HELPER!C[-1]=RC[-2]),0))"

Any thoughts?

Thanks

 

[acerlaptop]

If it's a one line If, then yes

Wow it's working. Thanks

 

[Fluff]

You're welcome & thanks for the feedback