V
Valeria
Hi,
my problems seems to be quite a common one, but I have not
seen any solution that may apply to my case yet.
I have two workbooks, A and B, B is a database and I want
to import in workbook A some cells of B that are around a
specified cell. (specified in A and lookedup in B).
The OFFSET function does not work in this case, because I
can't give any fixed reference cell (as for ex. "$A$1"),
as this cell is basically a looked up value coming from
workbook B.
To give an ex:
Workbook A (lookup) Workbook B (initial database)
lookup value: 2 1 r y v d
u u o
looked up range: 2 a n s e v
2 a n s e v p k
p k
3 d a k m o
the OFFSET would have to refer to the "2" cell in Workbook
B, and not A, for me to get the right cells. I can get its
address through formulas but OFFSET does not seem to like
it! (does it only work with fixed cells?)
I have tried posting this problem before but unfortunately
I cannot use the solution I got because it involves a
fixed cell in OFFSET. I can't use any filtering either as
data has to refresh automatically.
Is there a way I can perform this without using VBA?
Many thanks for your help.
Regards,
Valeria
my problems seems to be quite a common one, but I have not
seen any solution that may apply to my case yet.
I have two workbooks, A and B, B is a database and I want
to import in workbook A some cells of B that are around a
specified cell. (specified in A and lookedup in B).
The OFFSET function does not work in this case, because I
can't give any fixed reference cell (as for ex. "$A$1"),
as this cell is basically a looked up value coming from
workbook B.
To give an ex:
Workbook A (lookup) Workbook B (initial database)
lookup value: 2 1 r y v d
u u o
looked up range: 2 a n s e v
2 a n s e v p k
p k
3 d a k m o
the OFFSET would have to refer to the "2" cell in Workbook
B, and not A, for me to get the right cells. I can get its
address through formulas but OFFSET does not seem to like
it! (does it only work with fixed cells?)
I have tried posting this problem before but unfortunately
I cannot use the solution I got because it involves a
fixed cell in OFFSET. I can't use any filtering either as
data has to refresh automatically.
Is there a way I can perform this without using VBA?
Many thanks for your help.
Regards,
Valeria