Gord,

I get #NUM! with non-array entry, and #VALUE! with the data workbook closed.

HTH,
Bernie
MS Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
#VALUE! could indicate you did not array-enter the formula.

CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 08:13:36 -0700 (PDT), Mark767
wrote:

Bernie,

I am still getting the #Value! error.

I even went as far as making a new spreadsheet with just numbers in
each row and column and trying it again using your formula above in a
new worksheet all with the same names. Again the #Value! error, which
is strange because it was all numbers so I am not sure how the data
types could be mixed.

Any ideas ?


Mark.