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

sorry, still don't get you, Dennis

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

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

are also in Sheet2, yes?

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

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

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