#N/A = FALSE

  • Thread starter Thread starter Jon M
  • Start date Start date
J

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
 
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))
 
Back
Top