Adding user name associated with user id

  • Thread starter Thread starter fourlugas
  • Start date Start date
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
 
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))
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Formula returning an error 2
Adding data in columns based on criteria in more than one column.. 6
selecting randomly specific value in a list 8
#N/A In Cells 7
=I34*H34 without N/A 9
leve chart 5
#DIV error 2

Back
Top