Index, Match, when match data occurs in more than one row

[DetroitKnitter]

My brain hurts I hope I typed the match array correctly for this example.

How do you change this formula so that the result in column E shows the next occurrence on the sheet when there is identical cells in the matching formula?
I have a sheet with addresses I'm matching to another sheet with address where the result should be what is in B. Most of the time the data in the rows have something that is different like here I've typed the date to be different. What happens if the data in 2 rows are exactly the same?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]11/30/14[/TD]
[TD]2.57[/TD]
[TD]Jim Smith[/TD]
[TD]123 Main[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88"]=INDEX($B:$B,MATCH($D1,'ADDRESSES'!$A:$A,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12/1/14[/TD]
[TD]3.75[/TD]
[TD]Carol Hall[/TD]
[TD]555 South[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88"]=INDEX($B:$B,MATCH($D2,'ADDRESSES'!$A:$A,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]12/11/14[/TD]
[TD]4.38[/TD]
[TD]Randy Stepp[/TD]
[TD]1820 Brook[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88"]=INDEX($B:$B,MATCH($D3,'ADDRESSES'!$A:$A,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]12/16/14[/TD]
[TD]2.31[/TD]
[TD]Jim Smith[/TD]
[TD]123 Main[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88"]=INDEX($B:$B,MATCH($D4,'ADDRESSES'!$A:$A,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]12/22/14[/TD]
[TD]3.52[/TD]
[TD]George Good[/TD]
[TD]163 Golfview[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88"]=INDEX($B:$B,MATCH($D5,'ADDRESSES'!$A:$A,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

(wow, that's one bad looking table... sorry)

 

[rohith554]

I hope this resolves your problem.

http://www.mrexcel.com/forum/excel-questions/826698-match-find-2nd-occurence.html#post4035179

 

[DetroitKnitter]

Thanks rohith554 - I haven't had a chance to spend a few more hours (yes, hours) working on this. The information in the link looks great and I'm SO glad you shared the link! I probably won't have time to get into this issue for several more days

Thanks again for taking the time to respond!
Marlene