J
jtinne
Is it possible to have a cell return a value from another file that is saved
on a server without that file being opened. Here is the formula I am using:
=COUNTIF(OFFSET('P:\Manpower\[Copy of Manpower 10-25 to 12-30.xls]Daily
MP'!$A:$A,0,MATCH(F$3,'P:\Ohio\Manpower\[Copy of Manpower 10-25 to
12-30.xls]Daily MP'!$5:$5,0)-1),"*" & $B5 & "*")
but all I get is #VALUE! if this file is not open on the PC I'm using.
on a server without that file being opened. Here is the formula I am using:
=COUNTIF(OFFSET('P:\Manpower\[Copy of Manpower 10-25 to 12-30.xls]Daily
MP'!$A:$A,0,MATCH(F$3,'P:\Ohio\Manpower\[Copy of Manpower 10-25 to
12-30.xls]Daily MP'!$5:$5,0)-1),"*" & $B5 & "*")
but all I get is #VALUE! if this file is not open on the PC I'm using.