Ah ha!

You don't need to use those "complex" array formulas. You can use this:

=SUMPRODUCT(--(Sheet2!A$2:A$1116=A2),--(Sheet2!B$2:B$1116=B2),Sheet2!C$2:C$1116)

I replaced those array formulas with the one above and reduced the file size
from 271kb to 244kb. Initial calculation is now also "instant" versus ~5
seconds.

MrvinGover, on the other hand, can't use that type of formula. They're
returning text values.

Biff

"tiziano1" wrote in
message ...

MrvinGover Wrote:
T,

Did you get this to work? If so would you attach a copy of your
spreadsheet so I can glean some ideas on how to do it for myself?

Here is a simplified version of my spreadsheet. The formula in column
C
(sheet1) looks up the data in sheet2. In this example, the data in
sheet1
is the same as the one in sheet2 (as I said, this is a simplified
version of
my spreadsheet), but the important thing is that the formula suggested
by
Biff works...
Don't forget to hit CTRL+SHIFT+ENTER when you are finished writing the
formula.
--
tb


+-------------------------------------------------------------------+
|Filename: file1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4093 |
+-------------------------------------------------------------------+

--
tiziano1
------------------------------------------------------------------------
tiziano1's Profile:
http://www.excelforum.com/member.php...o&userid=29319
View this thread: http://www.excelforum.com/showthread...hreadid=490074