hide #N/A in multiple cells
 

Thanks for the response. So my formula should look like this:
=if(ISNA(VLOOKUP($A6,$A$106:$CB$148,2,FALSE),"",VL OOKUP($A6,$A$106:$CB$148,2,FALSE)

I will wait to hear back from you. Take care

Pete
"tjtjjtjt" wrote:

You formula shoule be:

=if(ISNA(Formula),"",Formula)

As you wrote it, you were missing the comma before the second formula.
Also, make sure you only have a = at the beginning of the formula.
--
tj


"Pete Elbert" wrote:

Cells have formulas set up in them and will not be used until the cells in
column A have a reference in them. The formula in most all of the cells look
something like this: =VLOOKUP($A6,$A$106:$CB$148,2,FALSE) Someone stated
that =if(ISNA(Formula),""Formula) would work, however, everytime I try to
apply it, I must be doing something wrong because I continue to get an error
message on the screen. Can anyone help?