Vlookup to return max value from multiple hits in Excel
Hi, can anyone help me with the below...
Im looking for a vlookup
formula which will give me the maximum number from a list which contains
multiple matches, i.e.
Lookup number 1 from column A, then give me the
largest number from column B
example table:
A B
-----
1 5
2 2
1 11
3 2
4 5
the result would be 11
thanks all!
Answer:
=MAX(IF(A1:A10=1;B1:B10))
(for formulas, depending on your country, you might have to change ; with , or the opposite