hide #N/A in multiple cells
 

Also, the """" in the middle of the formula, what is this and is there
something supposed to go in between the " " ? The formula I am putting
in looks like this:
=IF(ISNA(VLOOKUP($A6,$A$106:$CB$148,2,FALSE),"",VL OOKUP($A6,$A$106:$CB$148,2,FALSE)

This is coming back again as an error statement. I am not sure what to do.
Thanks again for the help.
"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?

hide #N/A in multiple cells
 

Hey,
You just need one more CLOSE BRACKET at the end to complete the formula. I
think!


"Pete Elbert" wrote:

Also, the """" in the middle of the formula, what is this and is there
something supposed to go in between the " " ? The formula I am putting
in looks like this:
=IF(ISNA(VLOOKUP($A6,$A$106:$CB$148,2,FALSE),"",VL OOKUP($A6,$A$106:$CB$148,2,FALSE)

This is coming back again as an error statement. I am not sure what to do.
Thanks again for the help.
"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?