Hi Ryan

Hopefully you haven't gone too far with this project to date.
If you are trying to input data for each day of the month in a separate
column, then have a column for the total for the month followed by
columns for each day of the succeeding month, followed by a total
column, then you will not be able to accommodate a full year of data -
unless you are using XL2007.

Earlier versions of XL have a limit of 256 columns. 365 (or 366) days
plus 12 monthly totals = 377

Also, I cannot see how your April total could be column 28. If you start
with 01 Apr 07 in column A, the 30 Apr 07 would be in column AD which is
column 30, and therefore April Total would have to be in column 31 - not
28.

I think you will need to undertake a fundamental re-design of your
layout.

If you post back with details of what you are trying to achieve, what
data you have etc. then we may be able to offer you further advice.


--
Regards

Roger Govier


"Ryan" wrote in message
oups.com...
Hi All,

I have two sheets.

1) columns with days & a Month ending total column
Similar to:
4/1/07 4/2/07 4/3/07...4/29/07 4/30/07 APRIL 07 TOTALS

2) Lookup totals by MONTH
Simliar to:
First, I pick the MONTH I want to look at
APRIL
MAY
JUNE, etc

Then, the columns look-up by MONTH name, what the totals are based on
a list that gives the 'column numbers' in the array that it should
look at. (i.e., column number 28 for April, 57 for May, etc)

This is fine, for one month, however I want to display the CURRENT
month (month selected above) and the PREVIOUS month (Month selected -
1 cell in the 'list') I was trying to find the formula to say "Look
at the month from the drop-down & then go to the list & select the
cell above the month I selected", in lay-man's terms.


Also, I have to manually update the column numbers when I get more
months (I haven't pre-set the column dates for every month in 2007),
how do I find the column number in Sheet 1, by looking up the 'label'
of the "APRIL 07 TOTALS" in sheet 1 & updating it on the list in Sheet
2?

Let me know if this is unclear.

Thanks for your help!!!
Ryan