If error function in excel 2003

[drewbny]

Is there a way to create a iferror equivalent function in excel 2003? THis way I wouldnt have to create double vlookups to eliminate the N/A in my worksheets. Wouldnt this result in worksheets calculating faster?

 

[philwojo]

The IF requires a "test", so that is your iserror(Vlookup) portion , if the vlookup fails then the Iserror portion is true, so for the IF formula you then return you "-", if the Vlookup finds its value then the Iserror portion is false, so then you actually do the Vlookup.

I hope that helps explain it for you.

 

[reneev]

yes, that helps. Thank you!