View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1
Default Sort then lookup

I am trying to create a lookup function that locates the max value in
column A and then identifies the value in the same row of column B. But
the trick is that I need the max value in column A that has a value in
the same row as column B that is greater than zero. So there are 2
rules that need to be met in the lookup function.

A B

2.89 -206,072,627.00
3.08 -173,714,739.00
13.52 -183,189,686.00
15.50 -149,160,742.00
43.84 -32,308,509.00
357,778,994.23 10,251,638.00
359,474,629.25 0.00


In the example above I would be trying to capture the value
10,251,638.00 via some lookup function.

Any thoughts on how to do this?