Trying to get data between dates ranges to analyze

T

Tony

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),LOOKUP(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a value from 1 table to a 2nd. 15
Function for returning quarter based on current date? 4
Automatically merging 2 data sets that share some values 4
How to Use VBA to Group and Transpose Data... 0
Date subtraction 1
Developing a formula that will return a value based on a date rang 3
Filtering data 2
Counting multiple occcurrences between date range 3

Top