IndexInPageList isn't going to cut it. This is a lookup of a certain value. Indeed, this may be what VLOOKUP does so the title of my post was slightly misleading. What I'm looking for is something that finds the index of max value of a certain property, then returns me another property at that index. Or, just gives me only the index of the max (or min) value and I'll do the lookup with a second function. In R, an expression like this would do it
In Excel, I believe you have to resort to ugliness like finding the max first, then the index of this value.
First sorting then lookup could work but is very inefficient. Sort is O(n.log(n)) at best, while I just need the max (or min), which is O(n). Also, not sure if I can do a sort + lookup inline in one expression (which is what I'm looking for), and it would still be hard to read.
Another alternative was to use a strategy so I have a visual way of doing the same. I prioritize by the lookup value, take the top-1, then pick the property of interest. Easier to understand but still as inefficient as sorting first.
So I'm still looking for a solution that is both efficient as well as easy to understand...