开发者

Finding cell in another column associated with max value in Excel

开发者 https://www.devze.com 2023-01-28 10:09 出处:网络
Say my structure is this: AB 10.1 20 5 开发者_开发问答42 47 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, F

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

精彩评论

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