Hi, can anyone help me with the below...
Im looking for a vlookup formula which will give me the MAXIMUM number from a list different worksheet which contains multiple matches, i.e.
Lookup number 1 from column A, then give me the largest number from column B
example table:
SHEETS1
A B
-----
1 5
2 2
1 11
3 2
4 5
the result would be 11:
SHEET2
-----
A B
1 11
And i currently use this formula in destination cells:
=IFERROR(VLOOKUP(A2;sheet1!$A$1:$B$1000053;2;);"")
i use" IFERROR" to turn "#VALUE!" into blank cell
thanks all!