Sure...
LOOKUP formula
Formula: copy to clipboard 
=LOOKUP(2, 1/($B$5:$B$10000=J5), $F$5:$F$10000)


will avaluate this array:
Formula: copy to clipboard 
$B$5:$B$10000=J5

As TRUE/FALSE values: Does each value in B column is equal to value in J5.

Then
Formula: copy to clipboard 
1/($B$5:$B$10000=J5)

Will evaluate those TRUE/FALSE as (for example):

1/{TRUE, FALSE, FALSE, TRUE, TRUE, FALSE, FALSE....}
into
1, DIV/0, DIV/0, 1, 1, DIV/0, DIV/0...

LOOKUP formula will now seek for number 2 in this range:
Formula: copy to clipboard 
=LOOKUP(2,


(Will work for any number greater than 1 but not less or equal).

Since it will never find it it will look until end of the range ignoring errors (this is crucial).

It will find last 1 and return corresponding value on that position in same size array of $F$5:$F$10000