=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.