Vlookup and Iserror or Isna function

[jsohng]

I having an issue with vlookup and If error. I have Excel 2003 and so I cant use Iferror, and rather Iserror. I have tried IF(Isna and Iserror and still keep getting an error in the formula.

=if(isna(VLOOKUP(VALUE(LEFT(I2281,4)),'C:\database.xls]data'!$A$2:$D$1640,4,0), "", VLOOKUP(VALUE(LEFT(I2281,4)),'C:\database.xls]data'!$A$2:$D$1640,4,0))

It keeps giving me an error in the "" field. Not sure what I am doing wrong here. any help would be appreciated. Thanks

[jsohng]

Oh man, I just got it. It was just the addition of one extra ) in the begining of the formula.

=if(isna(VLOOKUP(VALUE(LEFT(I2281,4)),'C:\database.xls]data'!$A$2:$D$1640,4,0)), "", VLOOKUP(VALUE(LEFT(I2281,4)),'C:\database.xls]data'!$A$2:$D$1640,4,0))

Thanks NBVC!