how update one cell based on another cells data

[Guest]

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.

 

[Guest]

Try

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

 

[Guest]

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

 

[Bernard Liengme]

=INT((MATCH(LEFT(C2,3),{"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"},0)-1)/3)+1
best wishes

 

[Guest]

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.