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?
|