I acquired maintaining our dept's individual employee's productivity log which I bloated with all these VLOOKUP's a looking to different Excel files like this:

=IF(ISERROR(VLOOKUP($C74,'\\Samba\Devv_lnx$\GLWRM\[hamboy.xls]hamboy_Lookup'!$A$2:$G$400,6,0))," ",VLOOKUP($C74,'\\Samba\Devv_lnx$\GLWRM\[hamboy.xls]hamboy_Lookup'!$A$2:$G$400,6,0))

I use ther IF(ISERROR() function so it won't display all those #N/A's.

How do I make this into VBA that it will not also display those #N/A's?