Problem:

We want to retrieve all the numbers from List1 (column A) that are greater than the number specified in cell B2.

Solution:

Use the INDEX, SMALL, IF, and ROW functions as shown in the following Array formula:
{=INDEX($A$2:$A$8,SMALL(IF($A$2:$A$8>$B$2,ROW($A$2:$A$8)-ROW($C$2)+1,100),ROW()-ROW($C$2)+1))}
Enter the formula in cell C2 and then copy it down the column until the #REF! error is returned.