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

 

[Bob Phillips]

Typo

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

HTH
--
AP

"sungen99" <[email protected]> a écrit
dans le message de (e-mail address removed)...

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]

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

 

[sungen99]

Works! thank you!