software

Hi Gents,
I am doing a vertical search to return some data from a
selected area.
Everything works fine unless the value I am looking for is not present
and therefore the formula returns #N/D, which ruins everything else I
intend to program.
What can I do to NOT see a NULL value (#N/D) but something else
instead?
I could use the IF formulas, but it does not work with quot;#N/Dquot;.

Thanks???
=If(IsNa(vlookup(quot;Aquot;,A:B,2,false)),quot;Something Elsequot;, vlookup(quot;Aquot;,A:B,2,false))
The operative part is the Isna() function.
Don't know if this is what you're looking for as I've not seen the quot;#N/Dquot;
error message before.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot; wrote:

gt; Hi Gents,
gt; I am doing a vertical search to return some data from a
gt; selected area.
gt; Everything works fine unless the value I am looking for is not present
gt; and therefore the formula returns #N/D, which ruins everything else I
gt; intend to program.
gt; What can I do to NOT see a NULL value (#N/D) but something else
gt; instead?
gt; I could use the IF formulas, but it does not work with quot;#N/Dquot;.
gt;
gt; Thanks
gt;
gt;

It's probably an international issue. I wonder if it might be =if(isnd...
--
Kevin Vaughnquot;Gary L Brownquot; wrote:

gt; ???
gt; =If(IsNa(vlookup(quot;Aquot;,A:B,2,false)),quot;Something Elsequot;, vlookup(quot;Aquot;,A:B,2,false))
gt; The operative part is the Isna() function.
gt; Don't know if this is what you're looking for as I've not seen the quot;#N/Dquot;
gt; error message before.
gt;
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Hi Gents,
gt; gt; I am doing a vertical search to return some data from a
gt; gt; selected area.
gt; gt; Everything works fine unless the value I am looking for is not present
gt; gt; and therefore the formula returns #N/D, which ruins everything else I
gt; gt; intend to program.
gt; gt; What can I do to NOT see a NULL value (#N/D) but something else
gt; gt; instead?
gt; gt; I could use the IF formulas, but it does not work with quot;#N/Dquot;.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;