A
aura
Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I am putting together a pay sheet with 30 col 500rows (about 5mb) as i get
close to filling it with employ name, start finish times pay rates etc excel
just crashes everytime i want to make further changes or save. The sheet
contains vlookup formulas which all have the error meesage that they refer to empty cells (on another worksheet?) but they return the correct values. (could these be the problem).
here is an example of the vlookup
=IF(ISERROR(VLOOKUP(C104,Employees!A:K,4,FALSE))=TRUE,"",IF(VLOOKUP(C104,Employees!A:K,4,FALSE)="","N/A",VLOOKUP(C104,Employees!A:K,4,FALSE)))
any help much appreciated aura
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I am putting together a pay sheet with 30 col 500rows (about 5mb) as i get
close to filling it with employ name, start finish times pay rates etc excel
just crashes everytime i want to make further changes or save. The sheet
contains vlookup formulas which all have the error meesage that they refer to empty cells (on another worksheet?) but they return the correct values. (could these be the problem).
here is an example of the vlookup
=IF(ISERROR(VLOOKUP(C104,Employees!A:K,4,FALSE))=TRUE,"",IF(VLOOKUP(C104,Employees!A:K,4,FALSE)="","N/A",VLOOKUP(C104,Employees!A:K,4,FALSE)))
any help much appreciated aura