IF function question

[JE]

This question I have is a bit of a challenging one - what the appropriate
IF formula is: I have a row of cells each labelled Jan, Feb, March and so
forth until the end of the year, December. Then I have a row of cells
labelled Q1, Q2, Q3, Q4.

Then I have a cell where I can select from a drop down list under Month:
1,2,3,4 etc and these will refer back to each month, respectively. e.g. Jan
is 1, Feb is 2 etc etc.

The bottom line is to be able to pull cell data on a quarterly, bi-annual,
or monthly basis so it would probably require defining the biannual months
and quarterly months:

Month Month
4 3
Year Year
2008 2008
Frequency Current Prior
Data 1 Monthly (formula to go here) formula to go here
Data 2 Quarterly (formula to go here) formula to go here
Data 3 Bi-Annually (formula to go here)
Monthly (formula to go here)
Monthly (formula to go here)

I think it would require specifying what months are Q1 and what month is 1,
2 etc all in the formula...

Thanks in advance

 

[Spiky]

This question I have is a bit of a challenging one - what the appropriate
IF formula is: I have a row of cells each labelled Jan, Feb, March and so
forth until the end of the year, December. Then I have a row of cells
labelled Q1, Q2, Q3, Q4.

Then I have a cell where I can select from a drop down list under Month:
1,2,3,4 etc and these will refer back to each month, respectively. e.g. Jan
is 1, Feb is 2 etc etc.

The bottom line is to be able to pull cell data on a quarterly, bi-annual,
or monthly basis so it would probably require defining the biannual months
and quarterly months:

Month Month
4 3
Year Year
2008 2008
Frequency Current Prior
Data 1 Monthly (formula to go here) formula to go here
Data 2 Quarterly (formula to go here) formula to go here
Data 3 Bi-Annually (formula to go here)
Monthly (formula to go here)
Monthly (formula to go here)

I think it would require specifying what months are Q1 and what month is 1,
2 etc all in the formula...

Thanks in advance

Well, maybe I'm misunderstanding you. It sounds like the source data
area is finite and static, so maybe just name all the ranges you need
with the same words as the list in your drop down and reference the
drop-down cell with INDIRECT.