There's no direct way to do that.
With some manipulation probably, but need more information.

Example:
This will do it
=MATCH(4,CHOOSE({1,2,3,4},A2,A4,A6,A8),0)

However, Understand that it's NOT returning the row # relative to the cell
If say 4 was in A4, that formula will return 2 (A4 is the 2nd cell specified in the formula)

To make it return the next lower value, just subract 1
=MATCH(4,CHOOSE({1,2,3,4},A2,A4,A6,A8),0)-1



Now there's probably far better/easier ways to do what you're looking for.
As Tim suggested, is there some pattern or criteria that determines which cells to look at ? That could probably be used.