Adding user name associated with user id

F

fourlugas

Also one other thing. Is there a way to leave it blank if there is n
record on that row instead of it displaying #N/A
 
F

Frank Kabel

Hi
use
=IF(ISNA(VLOOKUP(A1,'other_sheet'!$A$1:$B$1000,2,0)),"",VLOOKUP(A1,'oth
er_sheet'!$A$1:$B$1000,2,0))
 
Top