how to skip lines with formulas

[orsm6]

hi all - my source data (below) contains numbers, on another sheet i want to basically "lookup" all of the numbers which are greater than 100. hard to explain, so hoping the tables below help.

this is source data

Handover 2020.xlsx
	N
19	10
20	840824
21	16
22	840860
23	16
24	840890
25	15
Schedule Import

i need a formula that fills the column like this

Handover 2020.xlsx
	N
29	840824
30	840860
31	840890
32
33
Schedule Import

again i hope that makes sense.

source data sheet - Schedule Import
sheet where i have formulas to return values - Week 1

TIA

 

[orsm6]

this seems to work for me..... =IFERROR(INDEX('Schedule Import'!$N$42:$N$65,MATCH(1,('Schedule Import'!$N$42:$N$65>100)*(COUNTIF($C$38:C38,'Schedule Import'!$N$42:$N$65)=0),0)),"")

CSE

 

[Peter_SSs]

This wouldn't require the CSE

orsm6 2020-05-22 1.xlsm
	C
39	840824
40	840860
41	840890
42
43
bulk line

Cell Formulas
Range	Formula
C39:C43	C39	=IFERROR(INDEX('Schedule Import'!N:N,AGGREGATE(15,6,ROW('Schedule Import'!N$42:N$65)/('Schedule Import'!N$42:N$65>100),ROWS(C$39:C39))),"")

 

[orsm6]

This wouldn't require the CSE

orsm6 2020-05-22 1.xlsm
	C
39	840824
40	840860
41	840890
42
43
bulk line

Cell Formulas
Range	Formula
C39:C43	C39	=IFERROR(INDEX('Schedule Import'!N:N,AGGREGATE(15,6,ROW('Schedule Import'!N$42:N$65)/('Schedule Import'!N$42:N$65>100),ROWS(C$39:C39))),"")

thanks again for your help :D

 

[Peter_SSs]

thanks again for your help :D

No problem.