Working with your sample data, using MATCH() provides the desired answer.
=MATCH(22.4,A2:A13,1)
This version to deal with the #N/A error when your search value is lower than first range value.
=IF(22.4<=A2,0,MATCH(22.4,A2:A13,1))
and this version to account for exact match:
=IF(22.4<=A2,0,MATCH(22.4,A2:A13,1)-COUNTIF(A2:A13,22.4))
Bookmarks