how can i return multiple results using one lookup value?

[comalley88]

Hi,

I am dealing with a number of purchase orders with delivery dates in a separate column. Some PO's had a split shipment so two, or sometimes three different delivery dates for one PO. Is it possible to do a lookup and specify which delivery date i.e. first, second, third??

 

[Vidar]

Yes it's possible.
How will you choose which date to return?
And please post some example data with the expected results.

 

[steve the fish]

Vlookup will only return the first value it finds down the column from the top. You can use concatenation with vlookup if that helps? Or you can sort the data so the most recent is first. Depends what you are looking for.

 

[comalley88]

Hi, ive copied a section from the two columns (a and b) i'd be using for the lookup to populate a date colum (b) on a separate sheet

[TABLE="width: 133"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]725747[/TD]
[TD="align: right"]5-Oct-14[/TD]
[/TR]
[TR]
[TD="align: right"]725742[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725545[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725553[/TD]
[TD="align: right"]21-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725559[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725620[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725264[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725693[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725693[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]761568[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725264[/TD]
[TD="align: right"]31-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]725274[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]764717[/TD]
[TD="align: right"]31-Jul-14[/TD]
[/TR]
[TR]
[TD="align: right"]764712[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]764670[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]764700[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]746251[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]734755[/TD]
[TD="align: right"]7-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725693[/TD]
[TD="align: right"]31-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]761568[/TD]
[TD="align: right"]14-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]725264[/TD]
[TD="align: right"]31-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]725274[/TD]
[TD="align: right"]12-Jul-14[/TD]
[/TR]
[TR]
[TD="align: right"]764717[/TD]
[TD="align: right"]16-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]764712[/TD]
[TD="align: right"]26-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]764670[/TD]
[TD="align: right"]29-Aug-14[/TD]
[/TR]
[TR]
[TD="align: right"]764700[/TD]
[TD="align: right"]15-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]746251[/TD]
[TD="align: right"]16-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]734755[/TD]
[TD="align: right"]4-Sep-14[/TD]
[/TR]
[TR]
[TD="align: right"]734754[/TD]
[TD="align: right"]3-Aug-14
[/TD]
[/TR]
</tbody>[/TABLE]

if possible i want to look up either the unique or if multiple dates for a single PO, have a formula pull these through individually. I basically want the information from a download with multiple colums to update a front sheet with just the two columns of data above. Hope that makes sense