Calculating: (1 Processor(s)) problem with large number of array-formulas

Hi 'Exc-all',

I have an Excel file that is not too big (ca. 10Mb), but it has a big problem with a certain array formula:

Please Login or Register  to view this content.

(In words: It has to pick up the data in a different tab of:
a Row that matches a 'person' and a 'criteria',
and a colomn that matches a month)

This CTRL-Enter-formula is used ca. 2000 times in my spreadsheet and makes it aweful slow.
I already put my spreadsheet calculations on 'manually', but everytime I am updating the spreadsheet is almost crashing.

Does someone has a solution to this issue...?
(Maybe a different type of formula or maybe a VBA-code)

TIA

Wow, that helps already a lot!

I didn't knew that Excel was not recognizing that cells were empty.
I will test a bit, if the processor problem comes back, I will reply again.

Thanks a mil,
KR!