Help with Index Match Function Duplicate Returns

Occasional Visitor

I am having trouble with duplicate returns with index match function. In one column I have a set of names in another I have values. Below main array I have sorted values from low to high to create a ranking. I want to return that persons name next to their value in ranking. The formula below is working but when two values are the same it returns the first name on the list. I would like it to continue to the next name instead of duplicate. I am using 365. 




B3-B14 is the array of names, D3: D14 is the array of values

1 Reply


This is the idea. TRANSPOSE is added to spill results horizontally.