Hi all,
Wondering if anyone has any ideas on this problem.
I have a dynamic range that selects a range 4 columns wide and x rows down. The range is part of some external data I have imported from Access.
Here is the formula:
=OFFSET(External_Data!ExternalData1,1,1,COUNTA(External_Data!A:A),4)
I have two problems with this formula.
1. For some odd reason the part (External_Data!A:A) changes to B:B or C:C without me actually changing it!
2. I use this formula as the table array for a vlookup formula.
On another sheet in column L, the formula works fine. In column M the formula doesnt work, in column N the formula only seems to pick up half the table!
Why why why?!?!
Thanks in advance and merry christmas!