On Dec 12, 5:42 pm, "Peo Sjoblom" wrote:
=MATCH(1,(P1:P500<80)*(ISNUMBER(P1:P500)),0)

entered with ctrl +shift & enter

will give you the row number

=INDEX(P1:P500,MATCH(1,(P1:P500<80)*(ISNUMBER(P1:P 500)),0))

entered the same way will give you the value

=CELL("address",=INDEX(P1:P500,MATCH(1,(P1:P500<80 )*(ISNUMBER(P1:P500)),0)))

entered the same way will give you the address as a text string

--

Regards,

Peo Sjoblom

"tb" wrote in message

...

Is there a way to find the cell address where a specific value is?
If I wanted to know in which row (of column P) I have the greatest
value that is <= 80, how would I do that?
Thanks.
--
Tiziano

Thanks, Peo!
--
tb