software

My vlookup formual returns #N/A when there is not a match in my lookup table.
When there isn't a match, I would like the formula to return a balnk cell
rather than #N/A so that users don't think there are problems with the
formula. Any ideas?

Thanks

surround your formula like this

=IF(ISERROR(formula),quot;quot;,formula)
or
=IF(ISERROR(formula),quot;not in listquot;,formula)

quot;Fletchquot; wrote:

gt; My vlookup formual returns #N/A when there is not a match in my lookup table.
gt; When there isn't a match, I would like the formula to return a balnk cell
gt; rather than #N/A so that users don't think there are problems with the
gt; formula. Any ideas?
gt;
gt; Thanks

It works perfectly - Thank You!

quot;Slothquot; wrote:

gt; surround your formula like this
gt;
gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; or
gt; =IF(ISERROR(formula),quot;not in listquot;,formula)
gt;
gt; quot;Fletchquot; wrote:
gt;
gt; gt; My vlookup formual returns #N/A when there is not a match in my lookup table.
gt; gt; When there isn't a match, I would like the formula to return a balnk cell
gt; gt; rather than #N/A so that users don't think there are problems with the
gt; gt; formula. Any ideas?
gt; gt;
gt; gt; Thanks