On Dec 12, 6:50 pm, "Ron Coderre"
wrote:
(Formulas shown in sections for readability)

Try this regular formula:
=CELL("address",INDEX(J8:J65000,MATCH(MAX(
INDEX((J8:J65000<K6)*J8:J65000,0)),J8:J65000,0)))

or...this ARRAY FORMULA version,committed with CTRL+SHIFT+ENTER:
=CELL("address",INDEX(J8:J65000,MATCH(MAX(
(J8:J65000<K6)*J8:J65000),J8:J65000,0)))

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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, Ron! It works very well.
--
tb