Adding then next letter to a column letter list

[jdhfch]

Hi,

I am trying to create a forecasting spreadsheet which looks at previous years data to build a forecast for the month/year.

I am trying to make the lookup cells dynamic according to the date.

For example, May runs from columns DT:EX and Jun runs from EY:GB. So in May, I want the lookups to be from DT:EX on day 1, DU:EX on day 2 etc. In Jun it will run from EY:GB etc

I have found a way to extract the start/end refernces and make it dynamic by using CHAR(CODE(R12)+B3) but this also return other characheters (/}) etc. Is there any way to limit this to only include letters.. eg when it gets to Z, it restarts at A?

Please be gentle... relative newbie!

Rgds

Jason

 

[Norie]

Jason

How/where are you using CHAR(CODE(R12)+B3)?

Do you actually need to get the column letters?

Perhaps you could use some other function(s) to get the range(s) you need for your lookup(s)/whatever?

For example if you had the day number in DR2 this formula would return a partial sum of DT1:EX1 based on the day.

=SUM(INDEX(DT1:EX1,,DR2):EX1)

e.g. if you had 3 in DR2 it would SUM DV1:EX1.