Try something like this:

=INDEX(A12:A200,MATCH(MIN(D12:D200),D12:D200,0),1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mike K" wrote:

Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike