Conditional seaching and extrcting value<urg>

Hi,

I have a requirement to copy cells conditionally by seraching from another sheet. Below is the scenario explained in detail

Sheet1 Sheet 2
----------------------- --------------------
Source Result Col1 col2
1 a 1 a
2 b 2 b
3 d 3 c
4 e 3 d
5 g 4 e
6 x 6 x
7 h 6 r
8 - 5 g
9 - 7 h

From the above two sheets:
The value from source column should be searched in Sheet2!Col1 and the corresponding value should be printed in Result column of the sheet1.

If the source column repeats then the maximum value should be returned. eg: serching 3 in sheet2 returns two rows which has values c & d. so the greater of the two 'd' should be printed in the result column.

Any help would be greatly appreciated.