Dear all ,

in sheet 1, i have 2 columns with data, namely x and y,
all are numbers
x can have any numbers, while y has only two numbers either 0 or 1

in sheet 2, i would like to collect the data in the following way,
for every zero (from y column of sheet1), i want respective data of x and 30 data's below it.

i was trying with if and vlookup, didnt help me so far
can anybody help me ?
Thanks n advancee
regards
Kadi