Vlookup and get the maximum value
You need to use MAX + IF condition. With your data in ColA:B
In C1 enter 10
In D1 enter the below formula
=MAX(IF(A:A=C1,B:B))
If this post helps click Yes
---------------
Jacob Skaria
"Its me" wrote:
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
|