not to show error when using if(isna & vlookup)

hi,

I have two workbooks. One is the source that exported from accounting system, hence some account code may not appear if there is no transaction in that month. Another workbbok has a complete account code that linked to the source file by using if(isna & vlookup) function.

As mentioned, no transactions for that accounts mean that code will not appear in source file. hence the linked will show error in another file. How can i change the error to "-"?

thanks

If you are using ISNA and VLOOKUP in the usual way then you shouldn't get an error in the first place. Standard practice would be to use a formula a little like this

=IF(ISNA(VLOOKUP(A1,B2:C10,2,0)),"-",VLOOKUP(A1,B2:C10,2,0))

Then if A1 doesn't appear in the lookup range you'll get - rather than an error

Which formula are you using?

If(isna(vlookup(a19,'l:\vision\[cost by cost ctr.xls]98p10'!$b$1:$c$65536,2,false)),0,(vlookup(a19,'l:\vision\[cost by cost ctr.xls]98p10'!$b$1:$c$65536,2,false)))

&

if(iserror(vlookup($a101,'l:\vision\[cost by cost ctr.xls]98p10'!$a$1:$c$65536,3,false)),0,vlookup($a101,'l:\vision\[cost by cost ctr.xls]98p10'!$a$1:$c$65536,3,false))