In one workbook, in cell P2, I am using the formula: =MIN($O$4:$O$622) and in an adjacent cell, Z2, in the same workbook I am using the formula: =CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0))).
The result in Z2 gives the address of the minimum value within O4:O622.
This cell address then shows...