Lookup with offset

  • Thread starter Thread starter Ola Sigurdh
  • Start date Start date
O

Ola Sigurdh

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!
 
Back
Top