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