I have a list of clients with their corresponding amount outstanding.
I want to rank them;
Then use lookup with cells containing 1-10 so as to list the top 10 clients;
Only problem is that when the 7th and the 8th values are same both are
ranked 7;
Finally #N/A appears in the vlookup for "8"?

Anyway, how to overcome this?

--

Best Regards,
FARAZ A. QURESHI