Personally, I'd change it to this:

'Vlookup User Name and User Dept from the SAPUSERMASTER file
'User Name
Range("P3").FormulaR1C1 = "=IF(RC[-3]="""","""",IFERROR(VLOOKUP(RC[-3],[SAPUSERMASTER.xlsx]SAPUSERMASTER!R1C1:R1048576C2,2,0),""NOT INDICATED""))"
'User Dept
Range("Q3").FormulaR1C1 = "=IF(RC[-4]="""","""",IFERROR(VLOOKUP(RC[-4],[SAPUSERMASTER.xlsx]SAPUSERMASTER!R1C1:R1048576C3,3,0),""NOT INDICATED""))"

But, without both workbooks, I can't test whether or not it works.


Regards, TMS