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.