Dynamic Arrays

Giganews Newsgroups
Subject: Dynamic Arrays
Posted by:  chaz (chaz.288dky_1148337900.49@excelforum-nospam.com)
Date: Mon, 22 May 2006

Is there a way to set array bounds dynamically for functions such as
INDEX, VLOOKUP, etc?

I need to look up data within a specified timeframe.
The data is time-ordered stock market information.
The question I need to answer is:
"when did the XYZ stock's value first exceed $20 after Jan-1-2005"
I can use the INDEX and MATCH functions to find the first time the
stock exceeds $20, but I can't find a way to have the search start at a
row for a given date.
The data would be a series of rows of the form:

date  value  p/e  ...

Regards,
Chaz

--
chaz
------------------------------------------------------------------------
chaz's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34616
View this thread:http://www.excelforum.com/showthread.php?threadid=544486

Replies