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

725747	5-Oct-14
725742	14-Sep-14
725545	14-Sep-14
725553	21-Sep-14
725559	14-Sep-14
725620	7-Sep-14
725264	14-Sep-14
725693	7-Sep-14
725693	7-Sep-14
761568	14-Sep-14
725264	31-Aug-14
725274	14-Sep-14
764717	31-Jul-14
764712	7-Sep-14
764670	7-Sep-14
764700	7-Sep-14
746251	7-Sep-14
734755	7-Sep-14
725693	31-Aug-14
761568	14-Sep-14
725264	31-Aug-14
725274	12-Jul-14
764717	16-Aug-14
764712	26-Aug-14
764670	29-Aug-14
764700	15-Sep-14
746251	16-Sep-14
734755	4-Sep-14
734754	3-Aug-14

<colgroup><col><col></colgroup><tbody>
</tbody>

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