Dynamic Range
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:AH1 8,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 |
All times are GMT +1. The time now is 04:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com