This looks like it should work but doesn't.
ActiveCell.Formula = "=(IFERROR(VLOOKUP(N2,Sheet3!$A:$B,2,FALSE),"")"
I'm using Excel 2013 and hours of googling says this should work.
Edit: The VLOOKUP works on it's own. I get Runtime error 1004 when I add the IFERROR part.