Help with a Formula

[Guest]

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

 

[L. Howard Kittle]

Hi Jim,

Try this:

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

HTH
Regards,
Howad

 

[Guest]

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

 

[Guest]

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

 

[L. Howard Kittle]

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