I need to get a value out of a range when I know the rank.

I would like a symmetric function to RANK(value, range) which returns the
rank given a value in the range.

I can't do the vlookup type solution I see referenced in the other posting
because I cannot add an additional column next to the range to hold the ranks
(i.e., RANK(B1, B1:B10) filled into A1:A10).

I'm trying to avoid writing a macro, but need a single function that could
return the value in a set for a given rank that does not require adding extra
data to the sheet. The result in a tie doesn't matter because its the same
value, and if the rank didn't exist because of ties, I would expect an NA
consistent with RANK(value, range) when the value doesn't occur in the range.