Both of our formulas could return the incorrect value IF there is another
instance of the min even if the below evaluates to FALSE:

IF((list!$C$3:$C$7202=$B$4)

This works: (tested on a smaller range)

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

Biff

"Peo Sjoblom" wrote in message
...
Assume you want the value in column J

=INDEX(list!J3:J7202,MATCH(MIN(IF((list!$C$3:$C$72 02=$B$4),list!$I$3:$I$7202)),list!$I$3:$I$7202,0))

entered with ctrl + shift & enter, then copied across it will return K, L
etc



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Kevin Gallagher"
<Kevin.Gallagher.240wt0_1141271101.9736@excelfor um-nospam.com wrote in
message
news:Kevin.Gallagher.240wt0_1141271101.9736@excelf orum-nospam.com...

I have this which works....

{=MIN(IF((list!$C$3:$C$7202=B4),list!I3:I7202))}

This formala returns the value in column I (the minimum value that
meets the criteria), however once I find the minimum, I would also like
to know the values in the other columns within the same row (e.g. other
information about the row entry).

How can I find other infomation in the same row as the value I am
finding with the array formala above.

All help woudl be very much appreciated


--
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