Lookup Function

[WAC]

I need to have Excel llok up a value then return the value from another cell and have not been able to get it to work. The list is not sorted and the lookup value is not in the first column. The data looks like below:

Column A Column B
Jack 5000
Jill 5100
John 4530
Jane 5005

The numbers in Column B are always changing and I need to know who has the current highest number. In another formula I need to lookup who has the lowest number. I can get it to work if the numbers are but in the first column and in order but since these always change I can't do that.

Thanks for you help,

Wade

[Teethless mama]

For highest number:
=INDEX(A1:A100,MATCH(MAX(B1:B100),B1:B100,0))

For lowest number:
=INDEX(A1:A100,MATCH(MIN(B1:B100),B1:B100,0))

[WAC]

That works, Thanks!