how update one cell based on another cells data
 

Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.

how update one cell based on another cells data
 

Try

=IF(OR(D2="January",D2="February",D2="March"),1,IF (OR(D2="April",D2="May",D2="June"),2,IF(OR(D2="Jul y",D2="August",D2="September"),3,IF(OR(D2="Octoboe r",D2="November",D2="December"),4,"No Month")))

"eraasio" wrote:

Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.

how update one cell based on another cells data
 

=INDEX({1;2;3;4},INT((MONTH(DATEVALUE(D2&" 1, "&YEAR(NOW())))+2)/3))

"eraasio" wrote:

Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.

how update one cell based on another cells data
 

=INT((MATCH(LEFT(C2,3),{"jan","feb","mar","apr","m ay","jun","jul","aug","sep","oct","nov","dec"},0 )-1)/3)+1
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"eraasio" wrote in message
...
Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.

how update one cell based on another cells data
 

Actually, enter the following formula in cell E2, with the month name in cell
C2:
=INDEX({1;2;3;4},INT((MONTH(DATEVALUE(C2&" 1, 2000"))+2)/3))

It's such a habit to think the year is important, I forgot it wasn't here :-)
Makes the formula even more compact... also noticed the D2 should have been
C2 per your data.

"BoniM" wrote:

=INDEX({1;2;3;4},INT((MONTH(DATEVALUE(D2&" 1, "&YEAR(NOW())))+2)/3))

"eraasio" wrote:

Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.