Hi!

For the highest:

=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))

For the lowest:

=INDEX(A1:A4,MATCH(MIN(B1:B4),B1:B4,0))

Neither formula accounts for the possibility of ties.

Biff

"smck" wrote in message
...
I have a list of sales persons (the list varies from time to time), and
want
to query which sales person has the highest or lowest sales. I would like
to
get the return of the name and amount. Here is an example.

A B
John Jones 123
Mary JO 456
Luci Lu 6789
Homer Simpson 91

the result should return Homer Simpson 91 if I ask for the lowest and Luci
Lu 6789 if I ask for the highest.
I have tried using VLOOKUP and MATCH, MAX, MIN but not getting the desired
result. Maybe I am not using them in the correct syntax or maybe I am
choosing the wrong functions. Any help in this is greatly appreciated.

Thanks in advance.