Returning cell address instead of value

[lynn]

Is there a function that will give me a cell address ?
Example, I do a MIN function for a row of numbers. Instead
of it telling me what the lowest number is, I want to know
WHERE it is - D22 or wherever it may be. Can this be done ?

 

[Peo Sjoblom]

One way

=CELL("address",INDEX(Range,MATCH(MIN(Range),Range,0)))