Getting the next value in a list???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that the first column is the calendar month, second - nth
columns are different data regarding that month.

I then have a data entry area where the user indicates a starting month to
begin entering data (jun, jul, aug), etc. I can use the MATCH function so
that regardless of what format, etc. they type, I get the correct starting
month. What I can't figure out, is how to get it to go to the following
month. What I currently have is:

=INDEX(MM_YY,MATCH(Start_date,Start_Week, 1)+1,1)

where the +1 then has to be edited to +2, +3, etc. to move down the list.
Very kludegy and error-prone. Can someone think of a better way ... I'm
sorely stuck and it's been a few hours!!!

Appreciate the help,

Cindy
 
Hi Cindy!

Try this:

=INDEX(MM_YY,MATCH(Start_date,Start_Week, 1)+Row(A1),1)

The row reference really means the same as +1 but when you
copy down the reference will automatically increment to A2
which means +2, A3 which means +3, etc.

Biff
 
Cindy said:
. . . What I currently have is:

=INDEX(MM_YY,MATCH(Start_date,Start_Week, 1)+1,1)

where the +1 then has to be edited to +2, +3, etc. to move down the list.
Very kludegy and error-prone. Can someone think of a better way ... I'm
sorely stuck and it's been a few hours!!!
Click to expand...

Try

=INDEX(MM_YY,MATCH(DATE(YEAR(Start_date),MONTH(Start_date)+1,7),
Start_Week,1),1)
 
Back
Top