C
Colin Foster
Problem...
2 spreadsheets in different folders. One "Postcodes.xls" provides a
postcode/town lookup range for the spreadsheet "Data.xls". So, in DATA you
enter the postcode & a lookup searches down th erange "PCDS" within POSTCODES
to find a match.
However, when POSTCODES is not open, the lookup fails & returns #REF.
As soon as POSTCODES is open, the #REF resolves to the correct values.
The range PCDS is dynamically named using the OFFSET function
If I delete the dynamic range & set it as a static range, everything works
as it should!
Any suggestions/ideas why this happens & is there a way to get around it &
still use dynamic ranges?
Cheers
Colin Foster
2 spreadsheets in different folders. One "Postcodes.xls" provides a
postcode/town lookup range for the spreadsheet "Data.xls". So, in DATA you
enter the postcode & a lookup searches down th erange "PCDS" within POSTCODES
to find a match.
However, when POSTCODES is not open, the lookup fails & returns #REF.
As soon as POSTCODES is open, the #REF resolves to the correct values.
The range PCDS is dynamically named using the OFFSET function
If I delete the dynamic range & set it as a static range, everything works
as it should!
Any suggestions/ideas why this happens & is there a way to get around it &
still use dynamic ranges?
Cheers
Colin Foster