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