Lookup with offset

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

Have a look in help index for MATCH and then INDEX.

--
Don Guillett
SalesAid Software
donaldb@281.com
"Ola Sigurdh" <ola.sigurdh@nospamtelia.com> wrote in message
news:OfBtDhFmFHA.576@TK2MSFTNGP15.phx.gbl...
> 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
>
>

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