One way

Assuming the numbers are in col A and sorted in ascending order

Enter the target number in B1: 36 (say)
Put in B2: =IF(B1="","",MATCH(B1,A:A,1))
B2 will return the desired row #
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"vmv" wrote in message
...


For example
col1 col2 col3
row1
row2 3
row3 14
row4
row5 25
row6 36
row7
row8 47


For example I want to find the row of the firt number 35
The result must be row6.
Row1, row4, row7 are empty.