I guess your formula looks a bit strange to me.

Did you really mean to check G6, then use K70 in your formula?

If you build the formula manually (not using =indirect()), what's returned?

Maybe you have your folder/file/sheet references in the wrong spot????



Sandyl wrote:

Dave,

Thanks for the link - now getting data from the pull function but still
getting the error when using within the formula above. Am I missing
the obvious (more than likely!)?

--

Dave Peterson