Jack Sons wrote:
Earl,

What if that highest number in col A has more occurences, say six, and what
is wanted is the highest corresponding number in the ColumnToReturn which
will of course not necessarily be the "first" highest number found in col A.

So tha answer below would be 201.

A B

3 100
5 101
7 200
3 103
4 300
7 201
1 -600
2 201
7 104
5 301


Jack Sons
The Netherlands

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=MAX(VLookups(MAX(a1:a10),a1:b10,2))

Alan Beban