I have a col. A and Col. B


Column A Column B

10 44363
10 56634
20 26348
20 32688


If i enter "10" in column C, it should lookup in Col. A and return the max.
value of Col. B (56634)


Thru vlookup i am getting the only the first value only.

Could someone help in this regard