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" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
news:euNcfRbPGHA.3984@TK2MSFTNGP14.phx.gbl...
> Assume you want the value in column J
>
> =INDEX(list!J3:J7202,MATCH(MIN(IF((list!$C$3:$C$7202=$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@excelforum-nospam.com> wrote in
> message
> news:Kevin.Gallagher.240wt0_1141271101.9736@excelforum-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
>>
>