Assume your names are in the range A1:A3 and the corresponding numbers are in
B1:B3.

In another cell (i.e. C1) put this formula:
=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0))

In C2 put this formula:
=MAX(B1:B3)

Change the row/column references to fit your data
--
Regards,
Dave


"BigBuck98" wrote:

I have a datebase containing 2 columns. In one column I have a persons name
in the other column is a number associated with that name. I would like to
search the column with numbers and find that largest number and the persons
name associated with that number and they place that name and number in
another cell. Example of names and numbers appear below. The answer can be
in one column or two.
Can this be done?
Thanks in advance,
Gordon

Smith, George 230
Henry, Bill 210
Thomas, Frank 200


Answer: Smith, George 230