This is my code, it works fine. The only problem is when I get a #N/A. How can I return a blank instead of #N/A?
[VBA]Public Sub IndexMatch()
Dim lastrow
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
With Worksheets("Master").Range("c2:c" & lastrow)
.Formula = "=INDEX(Daily!$A$2:$P$65536,MATCH(A2,Daily!$A$2:$A$65536,),2)"
.Value = .Value
End With
End Sub[/VBA]
Thank you.