#N/A = FALSE

[Jon M]

I am trying to get rid of #n/a. Using ISNA OR ISERROR, I
Get "FALSE" not the value. The formula I am using is;

IF(ISNA(VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE)),"")

Any ideas as to what I am doing worng?

Thanks for any help

 

[Dave R.]

You need to repeat the VLOOKUP part if you are using it in an IF statement
in this way. For example;

=IF(ISNA(formula),"",(formula)

for yours (untested);

=IF(ISNA(VLOOKUP($A13&C$11,'PC
INPUT'!$A:$G,7,FALSE)),"",VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE))