Locate a Cell based upon criteria

[Stan]

I'm trying to locate a cell based upon certain criteria. For example:
=CELL("row",min(C6:C11)). What doesn't seem to work is using the Min
function. Any thoughts on the best way to return a cell location?

Many thanks for any help you can provide!

 

[Domenic]

Try...

=CELL("row",INDEX(C6:C11,MATCH(MIN(C6:C11),C6:C11,0)))

Hope this helps!