Thread: #N/A to blank
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] rothfussm@gmail.com is offline
external usenet poster
 
Posts: 2
Default #N/A to blank

Another method would be to use a dummy range.

For instance, if your vlookup results are in column B, then in column
C use the formula =if(iserror(B1),"",B1). Now hide column B.

Not as elegant a solution but it is much faster than the IFERROR/ISNA
methods above using the the formula twice.