INDEX helped. Thank you for the explanation as well so I stop looking for
what was wrong

"Dave Peterson" skrev:

There are some functions that don't work with closed workbooks. =offset() is
one of them.

Maybe you could use =index() instead?????

Raf wrote:

Hello,

I use the OFFSET function in workbook1, with a reference in workbook2.
When I open only workbook1 (without opening workbook2) it does not give me a
result but only a #Value.
Does not matter ig I chose "update" or "do not update".
As soon as Workbook2 is open, the results shows...

I have no problem of that kind with the lookup function...

I there any way to solve this ?

--

Dave Peterson