Hi!

There does appear to be a circular ref issue but that=20
shouldn't cause Excel to crash although that may be a=20
contributing factor!

By my calculations, you have 112,473 *robust* array=20
formulas just for this one operation. I think you're=20
having a serious system resource issue.

This site may have something to help:

http://www.decisionmodels.com/

Biff

-----Original Message-----
"Dennis G." wrote:
Max,
They're on separate sheets...

sorry, still don't get you, Dennis

This formula below is presumably in say, Sheet2??:
=3D{index('SHEET1'!$A$1:$AK$12000,MATCH(C2&"",'SHE ET1'!
$D$1:$D$12000&'SHEET1'!$E$1:$E$12000,0),30)}

and if so, the cells referred to in these following=20
lines: =20
This s located in cell b2 and in cell c2:j2 I have=20
the same formula with a=20
different number at the end.

are also in Sheet2, yes?=20

If so, then ..=20
Going by the above lines, for the formula in cell C2,=20
won't you be hit with a circular ref error ?

Perhaps you could paste the actual formulas=20
you have in Sheet2's B2, C2 and D2

--
Rgds
Max
xl 97
---
GMT+8, 1=C2=B0 22' N 103=C2=B0 45' E
xdemechanik <atyahoo<dotcom
----

.