Try...

=INDEX(E1:E31,MATCH(F1,A1:A31,0)+G1)

....where F1 contains your first criterion, such as a date, and G1
contains the number of rows down from the lookup value in which to
return.

Hope this helps!

In article <OfBtDhFmFHA.576@TK2MSFTNGP15.phx.gbl>,
"Ola Sigurdh" <ola.sigurdh@nospamtelia.com> wrote:

> Hello!
> Excel 2000
> Let´s see if I can explain what I need help with. I want to lookup a value
> in column A (1-31 dates) and then pull data from column E, the problem is
> that I dont know how many rows down from the lookup data the data i want to
> pull is. It could be 2 row´s or it could be15 row´s down from the lookup
> value. There is no blanks in the data in column E other then a blank row
> before the next row with a new date.
>
> Tia
> Ola