Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(List!Z3:Z7202,MATCH(TRUE,List!I3:I7202=MIN(IF(List!C3:C7202=B4,List!I3:I7202)),0))

Biff

"Kevin Gallagher"
<Kevin.Gallagher.240zcm_1141274401.6915@excelforum-nospam.com> wrote in
message news:Kevin.Gallagher.240zcm_1141274401.6915@excelforum-nospam.com...
>
> Thanks for the help Biff.
>
> I just need to return the contents of ONE of the cells (in a specified
> column) from the same row as the minimum value returned.
>
> e.g. the value in column Z
>
> Cheers
> Kevin
>
>
> --
> Kevin Gallagher
> ------------------------------------------------------------------------
> Kevin Gallagher's Profile:
> http://www.excelforum.com/member.php...fo&userid=7459
> View this thread: http://www.excelforum.com/showthread...hreadid=518104
>