RE: Offset/match returns #value error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Dave
That would definitely work, but ideally I'd like to avoid the necessity of
having the other spread*** open at all. If it comes down to a choice of
opening the other workbook or replacing formulae with values, I'll use
values. Good thought though - thanks :)
--
There are 10 types of people in the world - those who understand binary and
those who don't.


"Dave" wrote:

Hi,
One suggestion:
You could use a Work*** Open procedure to open the needed workbooks each
time you open this workbook.
You could also use a Before Close procedure to close them again.
Regards - Dave.

"Geoff" wrote:

The following function looks up a value in another workbook:

=OFFSET('PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$C$8,MATCH($A11,'PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$A$9:$A$96,0)+4,0)

Unfortunately when that particular workbook is closed, the function returns
a #VALUE! error - so the referenced spread*** needs to be open for the
formula to be evaluated. I could replace all the formulae with values but I
would like to preserve the reference to the other spread*** in the cells if
at all possible. Any suggestions?

--
There are 10 types of people in the world - those who understand binary and
those who don't.
.

Quantcast