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