Selction based on drop down

applebee

New member
Joined
Jun 1, 2011
Messages
15
Reaction score
0
Points
0
Hi

see this below

Q1 April May June
Q2 july august september
Q3 oct nov dec
Q4 jan feb mar


and the drop down says

select year and month : 2010.june

then i need to display april may and june
if april then my formula of excel needs to display only april

more detail is
if 2010.april now based onthis i need to select april month data from the Quarter1
if 2010.May is selected then i need to select april and may months data from Quarter 1
if 2010.june is selected then i need to select april , may and june i.e all the months data in the Quarter1

my question is how to write a formula based on this selection
the retrieving from data base i will take care

thanks for ur help
 
Top