How to make #NA appear blank?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In a long column of vlookup equations, some cells evaluate to #NA when the
table array does not contain the lookup variable. That's fine, but how do I
make those cells appear blank, or better yet, empty? I have tried
"=IF(VLOOKUP(C2,range2,10,FALSE)=NA(),"",VLOOKUP(C2,range2,10,FALSE))", but
this unexpectedly (to me) also evaluates to #NA.

Thank!

Boatman


.

Relevant Pages

  • RE: excel formulas
    ... converts a number from euros to a euro member ... Counts the cells that contain numbers in a database ... Specifies a logical test to perform ... Looks in the top row of an array and returns the value of the indicated cell ...
    (microsoft.public.excel.misc)
  • Re: excel formulas
    ... member currency, or converts a number from one euro member currency ... Counts the cells that contain numbers in a database ... Specifies a logical test to perform ... Looks in the top row of an array and returns the value of the ...
    (microsoft.public.excel.misc)
  • Re: Excel Cell Formats
    ... Disable the update of excel. ... Copy the cells from this new sheet to my selection ... Someone suggested that I create a dummy 2D array containing my ... new ordering, but for my selection only, not the entire row. ...
    (microsoft.public.excel.programming)
  • Re: Array Declaration Problem ??
    ... cells B11:B14:: numerical values ... Function Zroots2 (ar As Range, ai As Range, m As Integer, polish As String) ... instead of returning the array 3 results to the 3 vertical cells. ...
    (microsoft.public.excel.programming)
  • Re: Excel Macro Filtered Data in-place: cannot calculate Frequency of Visible Cells
    ... What you could do, perhaps, is to use the Advanced Filter, set a criteria ... I have implemented your suggestion for a separate> named range object SET to the original range that contains the whole> un-filtered list, ... But the data> returned is still based on the whole un-filtered list and not the> filtered, Visible Cells only. ... >>> Returns a frequency distribution as a vertical array. ...
    (microsoft.public.excel.programming)