Multiple Look up to return multiple values.

[Chris Babin]

Hi,
This is a bit hard to explain, and I am not so sure it can be done, so I attached an example. I would like to compare a couple of ranges namely unit and date, and where those items match, display the control numbers for those matching ranges. I know I can do this with a pivot table (with the date and control number in the row field, and expand the cont numbers), but for a number of reasons I can't use a pivot table for this particular application. Ideally the control numbers would be concatenated in one cell.
This is a small sample of a rather large spreadsheet, and the units in C1:E1 could change....which is why there are additional units in the data sheet.
Any help and assistance would be appreciated.