View Single Post
  #5   Report Post  
Dirk Franke
 
Posts: n/a
Default

Bob Phillips wrote:
Dirk,

There are many ways. You can either

track down the source errors and correct them

or you can trap the errors where they get used, for instance in G492, if the
formula is =VLOOKUP(.... you could use an error trap that says
=IF(ISERROR(VLOOKUP(...),"",VLOOKUP(..., etc although you will probably need
the German function names.

Hello Bob,

thanks for your reply. I am not familiar with tracking down errors in
excel. Could you give me an example?

Thanks Dirk