The SAPUSERMASTER data is dynamic .

When the reference cell is empty , it will return "0" instead of "NOT INDICATED"

Any idea?


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