Look up error handling question.

[sungen99]

I am trying to do a look up that is return a value of “” if there is an #N/A error (the data does not exist) but this formula is not working for me. Any ideas?

=IF(VLOOKUP(O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE)=ISNA(V1),"",(VLOOKUP(O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE)))


Thank you for your help.

[Ardus Petus]

IF(ISNA(VLOOKUP(...),"",VLOOKUP(...))

HTH
--
AP

"sungen99" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> I am trying to do a look up that is return a value of "" if there is an
> #N/A error (the data does not exist) but this formula is not working
> for me. Any ideas?
>
> =IF(VLOOKUP(O8,'[xx.Data.xls]XXXXX
> Valley'!$L$1:$R$100,2,FALSE)=ISNA(V1),"",(VLOOKUP(O8,'[xx.Data.xls]XXXXX
> Valley'!$L$1:$R$100,2,FALSE)))
>
>
> Thank you for your help.
>
>
> --
> sungen99
> ------------------------------------------------------------------------
> sungen99's Profile:
> http://www.excelforum.com/member.php...fo&userid=9144
> View this thread: http://www.excelforum.com/showthread...hreadid=541573
>

[sungen99]

does not seem to work. in my test i should return a "" but im still getting the #N/A error.

[Bob Phillips]

Typo

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(..))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ardus Petus" <[email protected]> wrote in message
news:[email protected]...
> IF(ISNA(VLOOKUP(...),"",VLOOKUP(...))
>
> HTH
> --
> AP
>
> "sungen99" <[email protected]> a écrit
> dans le message de news:
> [email protected]...
> >
> > I am trying to do a look up that is return a value of "" if there is an
> > #N/A error (the data does not exist) but this formula is not working
> > for me. Any ideas?
> >
> > =IF(VLOOKUP(O8,'[xx.Data.xls]XXXXX
> > Valley'!$L$1:$R$100,2,FALSE)=ISNA(V1),"",(VLOOKUP(O8,'[xx.Data.xls]XXXXX
> > Valley'!$L$1:$R$100,2,FALSE)))
> >
> >
> > Thank you for your help.
> >
> >
> > --
> > sungen99
> > ------------------------------------------------------------------------
> > sungen99's Profile:
> > http://www.excelforum.com/member.php...fo&userid=9144
> > View this thread:
http://www.excelforum.com/showthread...hreadid=541573
> >
>
>

[sungen99]

Works! thank you!