View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony tony is offline
external usenet poster
 
Posts: 313
Default Trying to get data between dates ranges to analyze

I am creating a spreadsheet to analyze product performance based on quarterly
data. It looks something like this.

Search for Data results between:

Beginning Date: Jan 1995 <--- Drop down menu
Ending Date: Dec 2000

Performance Data for all dates:

Date Product 1 Product 2 Product.....
Jan'80 6.9% 7.30% 2.0%
..
..
Feb'05 1.66 1.75% -3.84%

Out put Range:

Date Product 1 Product 2 Product.....

Jan'95
=IF(AND(A3=Parameters!$K$3,A3<Parameters!$K$6),LO OKUP(Parameters!$B$14,'Quarterly Returns Input'!$C$1:$AY$1,'Quarterly Returns Input'!$C$4:$AY$4),"")

The above formula is not working. Is there another method I could se that
would search for data based on the date?

Thank you for the help