F
Frank Kabel
Hi
one way
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
it can't find a reference in the range - for example, DDW
as in the above example ... then displays a #N/A. How can
I prevent this, as it is part of a column with an =SUM()
formula.
one way
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
("DDW",paymentplans,2,FALSE) which worls well except when
it can't find a reference in the range - for example, DDW
as in the above example ... then displays a #N/A. How can
I prevent this, as it is part of a column with an =SUM()
formula.