Look up error handling question.
 

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

Look up error handling question.
 

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

HTH
--
AP

"sungen99" a écrit
dans le message de news:
...

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

Look up error handling question.
 

Typo

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ardus Petus" wrote in message
...
IF(ISNA(VLOOKUP(...),"",VLOOKUP(...))

HTH
--
AP

"sungen99" a écrit
dans le message de news:
...

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

Look up error handling question.
 

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


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=541573

Look up error handling question.
 

Works! thank you!


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=541573