View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default How do I replace a "#N/A" formula result with a blank in excel?

Example:

Assuming the VLOOKUPs are say, in A1:A10

To mask the possible returns of #N/As
within the VLOOKUP range with conditional formatting ..

Select A1:A10
(ensure A1 is the active cell)

Click Format Cond Formatting
Formula is: =ISNA(A1)
Click Format button Font tab Font color white*? OK
Click OK at the main dialog
*choose a font color which matches the cell's fill color

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---