Ooops!

Caught a bug!

Try this instead:

=INDEX(List!Z3:Z20,MATCH(1,(List!C3:C20=B4)*(List! I3:I20=MIN(IF(List!C3:C20=B4,List!I3:I20))),0))

Biff

"Biff" wrote in message
...
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