Max,

Sorry just getting back to you... The underlying logic is:

I have on sheet2 some data -- say:
Product Cost Pack Tax Weight
Orange 1.50 6 .7 2lbs
Mango 3.00 12 .85 4lbs

On Sheet1 I have some data (12,000 rows)
User Product Quantity [Pack] [Cost] [Weight] [Tax]
Davis Mango 15
Leslie Orange 24
etc...

I use the function above to return the values that I need... I hope this
helps.

Thanks
Dennis G.






"Max" wrote:

Guess I was still floundering <g trying to grasp the underlying logic behind
the OP's intent from the descript given. And thinking maybe there exists a
better way (another formula ?) to achieve the same intent w/o getting into
sys resource issues.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Biff" wrote:

Hi!

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

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

This site may have something to help:

http://www.decisionmodels.com/

Biff