OFFSET PROBLEM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using two excel files, each in a unique directory. In file A I have
created an OFFSET formula which offsets from Col C, Row 3, in file B. using a
cell value in file A to determine the row_number to offset to.

This worked fine while I was working with both files open. After I saved
file A and closed file B, I reopened file A only to find #VALUE! in the cell
where the OFFSET formula was. How do I get around that?
 
Post your formula, you can use INDEX instead of OFFSET in many case and it
will work when the source workbook is closed


--


Regards,


Peo Sjoblom
 
Here's for formula -
=OFFSET('[SE Region LD Weekly Metrics 10_8_2007.xls]Cons Cust.
Summary'!$C$4,($G$14),0)

The formula in $g$14 in the "host" excel file is -

=MATCH($B$14,'[SE Region LD Weekly Metrics 10_8_2007.xls]Cons Cust.
Summary'!$C$4,0)+3

Thanks!
 
Back
Top