Hi all, really hoping someone here can assist. I have a large dataset of weather observations, then have a Summary sheet that finds the top 10 values for each category. I then need to find the corresponding Station Name for that given top 10 value. My challenge is that there can be duplicate values in the top 10 list. When I use VLOOKUP or INDEX/MATCH to find the corresponding station, it only lists one station for all the duplicate values in my top ten list. How can I get it to find the next station that corresponds to the first duplicate value, instead of seemingly stalling at the first occurrence of that value it finds? I've tried sticking an IF function in there to compare the station it's computing to the previous station, but still can't figure out how to get it to kick down to the next station in the list that has that duplicate value. (all I can get it to return is a basic value like ND, for example)

In this example, the 24 actually corresponds to 4 different stations, instead of just the one... but once it hits Middle Lake alphabetically, it refuses to look further. The formula I'm using is

=INDEX(Analysis!$I:$I,MATCH(Summary!G7,Analysis!C:C,0))

I feel like I'm missing something really obvious here...

excel1.GIF