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
the result would be 11
(for formulas, depending on your country, you might have to change ; with , or the opposite