Vertical search and NULL

[[email protected]]

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 "#N/D".

Thanks

[Gary L Brown]

???
=If(IsNa(vlookup("A",A:B,2,false)),"Something Else", vlookup("A",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 "#N/D"
error message before.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"[email protected]" wrote:

> 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 "#N/D".
>
> Thanks
>
>

[Kevin Vaughn]

It's probably an international issue. I wonder if it might be =if(isnd...
--
Kevin Vaughn


"Gary L Brown" wrote:

> ???
> =If(IsNa(vlookup("A",A:B,2,false)),"Something Else", vlookup("A",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 "#N/D"
> error message before.
>
> HTH,
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> If this post was helpful, please click the ''Yes'' button next to ''Was this
> Post Helpfull to you?''.
>
>
> "[email protected]" wrote:
>
> > 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 "#N/D".
> >
> > Thanks
> >
> >