Excel Made Easy

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

You can find similar Excel Questions and Answer hereunder

1) How can i filter multiple columns simultaneously in Excel

2) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

3) Vba to return week numbers in Excel

4) How can I clear all formats (formats alone not data) from a range of cells?

5) Vlookup to return multiple values in same cell in Excel

6) How can I remove hyperlinks from a range of cells?

7) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

10) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?