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@excelfor um-nospam.com wrote in
message news:Kevin.Gallagher.240zcm_1141274401.6915@excelf orum-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