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