VBA Index/Match in a Loop

[pras2012]

HI all,

am new to VBA excel.
some
i am trying to use the macro for index match but some am not able to get the that .

am using the below formaula .
={INDEX(Sheet2!P:P,MATCH(Sheet1!A2&Sheet1!$O$1,Sheet2!A:A&Sheet2!E:E,0))}

Note: Sheet1!$O$1 is constant criteria

Please help me with this

 

[MARK858]

What exactly do you mean by "but some am not able to get the that"?
The formula goes in the cell fine for me

Sub Test4()
Sheets("Sheet1").Range("C1").FormulaArray = _
        "=INDEX(Sheet2!P:P,MATCH(Sheet1!A2&Sheet1!$O$1,Sheet2!A:A&Sheet2!E:E,0))"
End Sub