hide #N/A in multiple cells
 

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?