One more interpretation:

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

or you could adjust the ranges
=INDEX(A9:A197,MATCH(MIN(D12:D200),D12:D200,0))
But that looks like a problem when you try to remember why the ranges don't
match.


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

--

Dave Peterson