Finding the first instance of a given number in a long column from the bottom up

[Marvo]

If you have a column of numbers, is there a way of looking up from the bottom to find the first instance of a number higher than the one you place in a box below?

So in the example picture, A11 would be the cell you'd want.

 

[Fluff]

For that you can use

=ADDRESS(XMATCH(A28-0.5,A1:A24,-1,-1),1,4)

 

[Marvo]

So the image is from the actual workbook.
The formulas are
Y14: =ADDRESS(XMATCH(ALL!$AG$5559+0.5,ALL!$AG$1:$AG$5558,1,-1)*1,11)
Y16: =ADDRESS(XMATCH(ALL!$AF$5559+0.5,ALL!$AF$1:$AF$5558,1,-1)*1,11)
Y19: =ADDRESS(XMATCH(ALL!$AG$5559-0.5,ALL!$AG$1:$AG$5558,-1,-1)*1,11)
Y21: =ADDRESS(XMATCH(ALL!$AF$5559-0.5,ALL!$AF$1:$AF$5558,-1,-1)*1,11)

These are all producing a result (shown in the image).

Y19 & Y21 are producing the correct result but I think this is because the formula has found a 9 (1 less than 10) and that happens to be the next lowest score.
However Y14 & Y16 are producing an incorrect result as they are looking for 11 (1 more than 10) but are ignoring higher numbers that come before an 11.

So I think I just need to alter the formulas to include greater than > and less than < but I can't find the right position.

This is so close to perfect.

 

[Marvo]

I've just realised, the greater than or less than wont work will it as we have been looking to match either 9 or 11. Bugger!

 

[Fluff]

Maybe

=ADDRESS(LOOKUP(9^99,IF(A1:A24>A28,ROW(A1:A24))),1,4)

 

[Marvo]

Yes, that all works perfectly. Thank you very much Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.