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