#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.
|