On Sheet 1 I have a list of "product codes" (Column C) and a corresponding "sale date" for those products (Column D). There are multiple occurrences of the same product codes in the list in column C, with different sale dates:
eg:
Product Sale date
code
387253 29/04/2013
491960 14/05/2013
491960 15/05/2013
491960 16/05/2013
536273 14/06/2013
571790 03/05/2013
641092 30/05/2013
909264 20/05/2013
909264 21/05/2013
On Sheet 2, I have a list of "product codes" (Column A) and in the adjacent column (column B) a list headed "date received". There are multiple occurrences of the "date received" for each product code.
eg:
Product Date received
code
4843 03/07/2013
4990 24/07/2013
5122 03/07/2013
38484 03/07/2013
38484 24/07/2013
38626 24/07/2013
40615 03/07/2013
45207 16/07/2013
45207 17/07/2013
57476 16/07/2013
57501 16/07/2013
60494 16/07/2013
I want to lookup a "product code" on Sheet 1 and return the corresponding, multiple "dates received" against that product code from Sheet 2 - with the results in Sheet 1, Column E, if possible.
I originally had the data in two separate pivot tables, but have taken to putting all the data in simple worksheet format and trying a look-up - but I dont know 1)how to return multiple values against each product code, and 2)from another work-sheet.
My brain is scrambled. Looked all over the internet, so confused.
Any solution? Thanks
Bookmarks