Can you use a vlookup (or hlookup) to return the name based on the NPV? You
may have a problem if you have ties, but with NPVs that may not be likely.

"Liz23" wrote:

I have a set of NPV values that I need to be automatically ranked when the
inputs change. I received a solution using the "Small" function, but I also
need to rank the name associated with that NPV.

Is that possible?