Hi,

I have a table like this:

A               B          
Name    January  
Tom      150,000
Bob       100,000
Jane      90,000
Lisa       200,000
Fred      50,000

Is there a way to use a lookup function to retrieve all of the names that
are, say, greater than 100K in descending order and all of the names that are
less than 100K in descending order?  Sorting is not an option.

My end result should look like:
Lisa      
Tom      
Bob      
Jane    
Fred    

Thanks!