B
Bob Umlas Excel MVP
=IF(ISERROR(VLOOKUP("DDW",paymentplans,2,FALSE)),0,VLOOKUP
("DDW",paymentplans,2,FALSE))
If it's a matter of simply not DISPLAYing the #N/A, select
the cell and use conditional format for =ISERROR(xx) where
xx is the cell address, then click Format button & select
a white font.
Bob Umlas
can't find, say DDW as in the example above, it returns a
#N/A. However, this cell is part of a =SUM() formula.
How do I get it to return correctly, to avoid #N/A's?
("DDW",paymentplans,2,FALSE))
If it's a matter of simply not DISPLAYing the #N/A, select
the cell and use conditional format for =ISERROR(xx) where
xx is the cell address, then click Format button & select
a white font.
Bob Umlas
("DDW",paymentplans,2,FALSE). This works, but when it
can't find, say DDW as in the example above, it returns a
#N/A. However, this cell is part of a =SUM() formula.
How do I get it to return correctly, to avoid #N/A's?