Find cell reference in an column of numbers?

[Geoff C]

I have an column of numbers, e.g.

a1 - 0.03
a2 - 0.17
a3 - 0.35
a4 - 0.54
a5 - 0.67
a6 - 0.83
a7 - 1.00


What I'd like is a formula that returns the cell reference of the first
number in the column that is above a specific number (say, 0.5). Can anyone
suggest a formula that would achieve this?

Many thanks,
Geoff.

 

[GRM via OfficeKB.com]

Assuming the column of numbers is sequentially ascending, place 0.5 in cell
b1 and try =MATCH(b1,a1:a7,1)+1

 

[Geoff C]

Thanks!

Assuming the column of numbers is sequentially ascending, place 0.5 in cell
b1 and try =MATCH(b1,a1:a7,1)+1

 

[Alan Beban]

Assuming the column of numbers is sequentially ascending, place 0.5 in cell
b1 and try =MATCH(b1,a1:a7,1)+1

For the actual cell reference you might modify it as

="A" & MATCH(b1,a1:a7,1)+1

Alan Beban