Thread: Taking off or hiding #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
  
Posts: 130
Default Taking off or hiding #N/A
This is my formula :
=VLOOKUP(C,SHEET2!$A:$B,2,FALSE)
I know there is a way to hide or take the "#N/A" off
that appared in " D" when" C" is empty.
Don't remenber how. Thanks for your help.
Reply With QuoteReply With Quote