Array Formula Over Network?

  • Thread starter Thread starter CalumMurdo Kennedy
  • Start date Start date
C

CalumMurdo Kennedy

Hi there,

I'm trying to lookup a value using three different criteria (returning
a fourth) in an external file using an array. This works fine when it
is in the same workbook or even when referring to another workbook on
the C:, however it doesn't work over a network - is this problem an
array or a network one?

Assuming it is an array one is there anything that could achieve the
same goal over a network?

Best Regards,

CalumMurdo Kennedy
 
I'm trying to lookup a value using three different criteria (returning
a fourth) in an external file using an array. This works fine when it
is in the same workbook or even when referring to another workbook on
the C:, however it doesn't work over a network - is this problem an
array or a network one?

Assuming it is an array one is there anything that could achieve the
same goal over a network?
Click to expand...

Show us the formula. It may trigger some ideas. Otherwise, good luck.
 
Harlan said:
...



Show us the formula. It may trigger some ideas. Otherwise, good luck.
Click to expand...


=sum(($B$4='F:\BUDGETS\[VISIT NUMBER.xls]VISIT
NUMBER'!$A$1:$A$234)*($B5='F:\BUDGETS\[VISIT NUMBER.xls]VISIT
NUMBER'!$B$1:$B$234)*($C$4='F:\BUDGETS \[VISIT NUMBER.xls]VISIT NUMBER
'!$C$1:$C$234)*'F:\BUDGETS\[VISIT NUMBER.xls]VISIT NUMBER'!$D$1:$D$234))

Basically it is a number of (A1=B1:B10)*(A2=C1:C10)*(D1:D10)
Hope this helps,

Regards,

CalumMurdo Kennedy
 
...
...
=sum(($B$4='F:\BUDGETS\[VISIT NUMBER.xls]VISIT NUMBER'!$A$1:$A$234)
*($B5='F:\BUDGETS\[VISIT NUMBER.xls]VISIT NUMBER'!$B$1:$B$234)
*($C$4='F:\BUDGETS \[VISIT NUMBER.xls]VISIT NUMBER '!$C$1:$C$234)
*'F:\BUDGETS\[VISIT NUMBER.xls]VISIT NUMBER'!$D$1:$D$234))
Click to expand...
...

Since 'sum' isn't capitalized, it appears you're not copying the formula from
Excel and pasting into your newsgroup posting. Anyway, the formula you posted
contains a stray ending space in the 3rd instance of the worksheet name 'VISIT
NUMBER'. Check that.
 
Back
Top