I need help with a formula, I have spent all day trying to program one cell.
I have two columns of numbers. I need a formula that would determine the max
value from the first column, and then display the number from column two that
is in the same row. I am using Excel 2003.

thanks for you help

Hi Jim,

Try this:

=VLOOKUP(MAX(A1:A9),A1:B9,2,0)

HTH
Regards,
Howad

"Jim A" wrote in message
...
I need help with a formula, I have spent all day trying to program one
cell.
I have two columns of numbers. I need a formula that would determine the
max
value from the first column, and then display the number from column two
that
is in the same row. I am using Excel 2003.

thanks for you help

Try this:

With
Col_A contains values
Col_B contains values

This formula finds the maximum Col_A value and returns the corresponding
Col_B value
C1: =VLOOKUP(MAX(A:A),A:B,2,0)

or..this range specific alternative
C1: =VLOOKUP(MAX(A1:A10),A1:B10,2,0)

Note: if the max value occurs more than once....it returns the first
instance.
Is that OK?

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jim A" wrote:

I need help with a formula, I have spent all day trying to program one cell.
I have two columns of numbers. I need a formula that would determine the max
value from the first column, and then display the number from column two that
is in the same row. I am using Excel 2003.

thanks for you help

What does the 2 and 0 represent at the end of the formula?

"Ron Coderre" wrote:

Try this:

With
Col_A contains values
Col_B contains values

This formula finds the maximum Col_A value and returns the corresponding
Col_B value
C1: =VLOOKUP(MAX(A:A),A:B,2,0)

or..this range specific alternative
C1: =VLOOKUP(MAX(A1:A10),A1:B10,2,0)

Note: if the max value occurs more than once....it returns the first
instance.
Is that OK?

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jim A" wrote:

I need help with a formula, I have spent all day trying to program one cell.
I have two columns of numbers. I need a formula that would determine the max
value from the first column, and then display the number from column two that
is in the same row. I am using Excel 2003.

thanks for you help

Hi Jim,

The 2 is the number of columns to the right that the value will be returned
from.

The 0 (you can also use FALSE) is the fourth argument of the lookup formula
to look for and exact match. And the list does not need to be sorted.

If you used 1 (or TRUE, or omit all together) and there was no exact match,
you get the next closest to the match. Your list must be sorted.

HTH
Regards,
Howard

"Jim A" wrote in message
...
I need help with a formula, I have spent all day trying to program one
cell.
I have two columns of numbers. I need a formula that would determine the
max
value from the first column, and then display the number from column two
that
is in the same row. I am using Excel 2003.

thanks for you help