Hi, this sounds like it should be really easy but I am a bit stumped.
I have a list of names and test scores, Names in A, test scores in B. I want to return a list on another sheet of the students who got over a certain test score and the score they got. I can do it with vlookup but I have to copy and paste the formula and I get gaps in the list. How can I return this data without leaving gaps in the list?

Name Score
Fred 12
Alice 14
Bob 6
George 4
Mildred 10
Graham 8


I want it to return names of students with scores >=10

by using lookup and copying the formula I get

Fred 12
Alice 14


Mildred 10

I want it to look like this

Fred 12
Alice 14
Mildred 10


Thanks

Phil