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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a big matrix in Word 2013 5
Filtering data 2
Autonumber field in Excel that behaves the same as Access 0
Some slides are blank 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
create pull down menu 1
Problems created by Recent updates to Outlook 365 0
Confusion over where user templates are stored in Word 1

Top