Finding cell in another column associated with max value in Excel
Say my structure is this:
A B
1 0.1
2 0
5 开发者_开发问答 42
4 7
And in cell C1 I want the value in B that is associated with the maximum value in column A - in this case 42.
=VLOOKUP(MAX(A:A),A:B, 2, FALSE)
That is: "lookup the maximum value if column A in the table of columns A to B and return the value in the second column"
精彩评论