Offset Function

  • Thread starter Thread starter Kcoakley
  • Start date Start date
K

Kcoakley

I am using the offset function on many of my sheets and have made them all
identical so that this runs smoothly/dynamically update information. I would
now like to pull information using this function from another workbook. When
I try to do this I receive a "VALUE#" error. How I can I pull in this
information using either this function or one that is similar in nature?
 
You can use index instead since offset does not work if the source book is
closed

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OFFSET Function 1
Using the OFFSET function within SUMXMY2 4
Dependent drop down dynamic range formula, off sheet. 7
using offset function 3
Offset every 27th row in a column that is 2 cells wide (merged cel 4
Error in Function OFFSET 5
Exporting data using Pulldown List & VLOOKUP 1
OFFSET 1

Back
Top