I am working on a spreadsheet to analyze data during different periods of
time. I am having difficulting creating a formula (tried imbeded if, and,
then statements unsuccessfully). How can I easily have a formula search for
product results easily between a beginning and ending dates so that I can
analyze that information only between the selected dates? The spreadsheet is
setup something like this:

parameter tab:

Beginning Quarter: Drop down of dates (i.e. 4th Quarter 1985)

Ending Quarter: Drop down of Dates (i.e. 1st Quarter 1999)

Input data tab:

Quarters Product 1 Product 2 Product....

1Q 1980 6.90 7.30 15
2Q 1980 1.5 0.520 -.01
..
..
..
4Q2004

Out Put tab:

Date Product 1 Product 2 Product.....

4Q1985
..
..
..
1Q1999

Results

Std Deviation

T-Statistic

etc...


thank you for the help