Hi, I have 2 columns of data. Column A with dates and Column B with values. I have the same column B values in another sheet and I would like to return the matching date to the value. The problem is that some of the values are identical and they are only matching the first date that is found rather then all subsequent dates. Below is an example of what I mean however note that with the real date I'm working with, there are over 200 values with multiple values being the same - ie. I have lots of occurances of 5.8, lots of 6.3 etc.

Column A Column B
30-Jun-98 7.0
31-Dec-99 6.5
31-Jan-00 7.0
31-Mar-01 6.1

The result I keep getting when using an INDEX/MATCH formula is that for all cells containing value 7.0, only date 30-Jun-98 is returned. Is there a formula that we can write that will say "if 30-Jun-98 has already been returned, then find the next corresponding date to value 7.0"?

If anyone can shed any light on this I'd really appreciate it.

Thanks heaps.