It should be:
=IF(ISNA(VLOOKUP($A6,A106:$CB$148,2,FALSE)),"",VLO OKUP($A6,A106:$CB$148,2,FALSE))

You were missing a close paren after the first VLOOKUP to end the ISNA
funtion, and there was a close paren missing at the end of the formula to end
the IF function.
--
tj


"Pete Elbert" wrote:

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?