Hi,
Try this
=MAX(INDEX((C4:C7=C9)*(D4:D7),,1))
C9 holds 10
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Its me" wrote in message
...
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