False If Statement that moves to next row

[Gattaca]

Hello all..I'm trying to create an if statement that will look to the next row to fill in the data if it is false until it finds the true value. I can get it to find it but when I switch to the next value it leaves the first rows blank until it hits the true statement. Example - looking for "Brian" but the first instance of Brian is not until row 18, the first 17 rows show blank and then the 18 row begins filling data.