Reference a number from a different column in a formula
 

I have 2 sets of numbers in 2 columns A and B example:

1 5
2 8
3 36
4 52
5 10

=MAX(B1:B5)

How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I
need index, offset, match?

Reference a number from a different column in a formula
 

=INDEX(J:J,MATCH(MAX(K1:K5),K:K)-1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rhhince" wrote in message
...
I have 2 sets of numbers in 2 columns A and B example:

1 5
2 8
3 36
4 52
5 10

=MAX(B1:B5)

How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I
need index, offset, match?

Reference a number from a different column in a formula
 

Hi,

You could use

=LOOKUP(MAX(B1:B5,4)-1,B1:B5,A1:A5)

--
Thanks,
Shane Devenshire


"rhhince" wrote:

I have 2 sets of numbers in 2 columns A and B example:

1 5
2 8
3 36
4 52
5 10

=MAX(B1:B5)

How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I
need index, offset, match?