Solved: VBA Index/Match Help

[Bob Phillips]

Oops, my bad.

[vba]

Public Sub IndexMatch()
Dim lastrow
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
With Worksheets("Master").Range("c2:c" & lastrow)
.Formula = "=IF(ISNA(MATCH(A2,Daily!$A$2:$A$65536,)),"""",INDEX(Daily!$A$2:$P$65536,MA TCH(A2,Daily!$A$2:$A$65536,),2))"
.Value = .Value
End With
End Sub
[/vba]