Vlookup with duplicate values

Need a little help trying to develop a simple shipping/tracking schedule. Basically what I have below in the first column are ship set sequences, 2nd column are dates and 3rd column is ship set sequences again. So it reads set 4808 ships on 11/21/2013 along with 4809. Then the truck returns later that day with previous shipments in the 3rd column. On the return trip set 4788, which was sent out 2 weeks prior, will come back along with 4789. I wanted to use a simple Vlookup to search for date 11/21/2013 and return the corrisponding ship set that went out on that date. Since 2 sets shipped on the same date, have duplicate dates on 2 ship sets and the Vlookup is ignoring the 2nd set. I partially solved the problem by creating a column that looks for duplicate entries and adds +1 to the ship set which works 95% of the time. I need something that will return only 1 4788 and then a 4789 as the table array reads.


What I have...

4808 11/21/2013 4788
4809 11/21/2013 4788
4810 11/22/2013 4790
4811 11/26/2013 4793
4812 11/26/2013 4793
4814 11/27/2013 4796
4815 11/27/2013 4796
4816 12/2/2013 4798
4817 12/2/2013 4798
4818 12/3/2013 4800
4819 12/3/2013 4800
4820 12/4/2013 4802
4821 12/4/2013 4802

What I need...


4808 11/21/2013 4788
4809 11/21/2013 4789
4810 11/22/2013 4790
4811 11/26/2013 4793
4812 11/26/2013 4794
4814 11/27/2013 4796
4815 11/27/2013 4797
4816 12/2/2013 4798
4817 12/2/2013 4799
4818 12/3/2013 4800
4819 12/3/2013 4801
4820 12/4/2013 4802
4821 12/4/2013 4803

On the return trip set 4788, which was sent out 2 weeks prior, will come back along with 4789.

How did you got that ?
Is it 4788+1 ?

Also, it would be helpful if you could upload a sample workbook? thanks.

Regards,
DILIPandey
<click on below * if this helps>

not sure if this is what you want...

=IF(iserror(vlookup(X11,O:O,1,false)),"",VLOOKUP(W11,J:L,3,FALSE))

Hello,

Vlookup and all other lookup will only return the first result they encounter.

You can bypass the duplicated result, and jump to the next, you will need to use an Array formula with INDEX, SMALL and COUNTIF.

As dilipandey suggested, can you provide a small sample file with dummy data? It will be much easier for other to help you also.

Thanks Lemice for seconding my opinion.

bperkins, awaiting your response thanks.


Regards,
DILIPandey
<click on below * if this helps>