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""))"
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I managed to fix it ! Thanks for the help ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
fluffyvampirekitten 
Register To Reply
Bookmarks