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