kmc wrote:
I have a file that has item numbers in column A for multiple sites in sheet 1
(A9:A7425). In column E in sheet 1 are the code dates for those item numbers
(E9:E7425). The item number may be listed up to 55 times for all the code
dates that it has. The code date may be all numeric or alphanumeric.

On Sheet 2 I have in Column A the item numbers for only 1 site (A2:A113). I
need to find all the code dates from sheet 1 that match each item number in
sheet 2. Not all the item numbers from sheet 2 will be listed in sheet 1.
Is there a way to do this?



Look at this:

http://tinyurl.com/dncmom

If you still need help, post your worksheet on www.savefile.com and I can take a
look at it.