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.