T
tiptoe
Following on from previous questions I have posed I know I need to
create defined name with an Offset formula to drive a series within a
chart. My problem is that the Offset reference is also variable (can
be any month form Jan through to Dec) .
The defined name formula I have come up with to do this is not
accepted:
=OFFSET('Data Sheet (2)'!ADDRESS(6+
(MATCH(VLOOKUP(eurosdate,AH7:AH18,1,FALSE),AH7:AH18,0)),34),
0,20,1,-20)
If it helps, I have a formula in a worksheet ('Data Sheet' (2)!) that
returns a Month, e.g. Feb. Using this outcome, I then need to look
through a vertical list of months Jan to Dec, identify the matching
month and use the data contained in x20 cells located immediately to
the right of the selected month to drive a chart series contained on
another worksheet (Europe!).
Any help would be appreciated.
Bob
Nottingham UK
create defined name with an Offset formula to drive a series within a
chart. My problem is that the Offset reference is also variable (can
be any month form Jan through to Dec) .
The defined name formula I have come up with to do this is not
accepted:
=OFFSET('Data Sheet (2)'!ADDRESS(6+
(MATCH(VLOOKUP(eurosdate,AH7:AH18,1,FALSE),AH7:AH18,0)),34),
0,20,1,-20)
If it helps, I have a formula in a worksheet ('Data Sheet' (2)!) that
returns a Month, e.g. Feb. Using this outcome, I then need to look
through a vertical list of months Jan to Dec, identify the matching
month and use the data contained in x20 cells located immediately to
the right of the selected month to drive a chart series contained on
another worksheet (Europe!).
Any help would be appreciated.
Bob
Nottingham UK