开发者

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"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜