ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trying to get data between dates ranges to analyze (https://www.excelbanter.com/excel-programming/326700-trying-get-data-between-dates-ranges-analyze.html)

tony

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


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com